How to find the last row being used

[Barbados]

Hi all,

This question has been asked millions of time but I couldn't find the answer. So here we go again:

I have a named range, say 'sellDate'. This refers to some header of a column containing dates, so this date refers to only 1 cell. How do I find the last row of the column in which 'sellDate' has been defined. I played around with something like Range("sellDate").Rows.Count.End(xlUp).Row but that isn't working.

Thanks for the help.

[TMS]

Please Login or Register  to view this content.

Pick a column that will definitely have data in the last row, like a key or ID field.

Regards, TMS

[Barbados]

Thanks for the reply. But I need to know how I can use my ranged name 'sellDate' in here.

[TMS]

Maybe:

Please Login or Register  to view this content.