Hi,
My 2 cents again. Hope I'm not interfering too much.
You mentioned
Quote:
|
Where you asked that I perform the End Down function while in K1, and asked what row I was in- it shot me to the last possible row (1,048,576). Not sure if that was what it was supposed to do or not! But my answer is 1,048,576!
|
I think the reason is if in the range you specified there in no data the code will take you to the "Last" row in that column. If however, you have date in row 20 you will then see that as the "Last" row.
Added: I too learned the "Old Fashion" way. Trial and error.