I have a worksheet into which a file is imported daily and can vary in the
number of rows it occupies. I then does other things for which I have
recorded a macro, which includes going to the end cell. I use this to create
a range that then does lookups and creates data on another sheet. If the data
imported creates more rows than the sheet I have recorded the macro on I
don't get the extra data copied to the other sheet. I need a macro that will
tell me the last row on the imported sheet to set the end cell for the range
for the rest of my macro. Hopefully this will then "float" and I will always
get all of my data examined and transferred.



Regards
Chris.