Retrieve last cell with data

[JimDandy]

I have a worksheet that records information from multiple sheets. What
need to retrieve is the data in the last cell (whatever cell tha
happens to be) in a specific column of each worksheet that has data i
it. The range in each worksheet has a different number of entries in i
so I cannot predict which cell is the last one with data in it

 

[Frank Kabel]

Hi
see:
http://www.xldynamic.com/source/xld.LastValue.html

 

[JimDandy]

That was extremly helpful and comprehensive....

Thanks again Frank