Scot,

It starts looking in cell IV2 and moves left (xltoleft) until it finds a
populated cell and selects the cell above that.

Mike

"Scott" wrote:

That didnt seem to work. What is the "IV2" for?

"Mike H" wrote:

Try,

Range("IV2").End(xlToLeft).Offset(-1, 0).Select

Mike

"Scott" wrote:

I have a series of dates in cells a1:z1 and some numeric data in some of the
cells a2:z32. I would like to find the last column that contains a value in
any of the data cells (all columns after that contain a blank) and then
select the date cell that corresponds to it. Can anyone help? Thanks.

a b c d e ... z
1 1/07 2/07 3/07 4/07 5/07
2 5 0 7 2
3 0 0
4 0 1 6 98 12
5 4 3 0 0 1
.
.
32

In this example it would pick 5/07