Finding the value of the last populated cell in a defined column

beveritt · Mar 22nd 2005

Hi Everyone,

I have a quick question that I'm sure is pretty easy, but I'm having a problem getting it. Ok here's the scenario...I need to find what the value of the last populated cell of a certain column is. The cell will always be different, but the column will alway remain the same. For example, the column will always be "K" and I just need to find out what the value of the last populated cell is in that column. Thanks for any help!

-beveritt :rock:

Anonymous · Mar 22nd 2005

Re: Finding the value of the last populated cell in a defined column

The following should do it.

Code

Sub test()
Dim It as Variant
It = Range("K65536").End(xlUp).Value
MsgBox It
End Sub

beveritt · Mar 22nd 2005

Re: Finding the value of the last populated cell in a defined column

Thanks thomach,

I'll give it a try in the morning!

-beveritt :rock:

**Krishnakumar** · Mar 22nd 2005

Re: Finding the value of the last populated cell in a defined column

Hi beveritt,

To get the last numeric value try,

=LOOKUP(1E+307,K:K)

To get the last text value try,

=LOOKUP(REPT("z",255),K:K)

pradeep_atm · Mar 22nd 2005

Re: Finding the value of the last populated cell in a defined column

Hi Kris,

It's a good one. Can you explain these as well.

How did you manage to get these so easily..

Thanx

**Krishnakumar** · Mar 22nd 2005

Re: Finding the value of the last populated cell in a defined column

Hi Pradeep,

The following link would give you a detailed explanation on this topic.

Last Value in Range

HTH

Finding the value of the last populated cell in a defined column

Participate now!

Share