Automatically finding the last row in a SS
try ctrl+down arrow in that column
"TPenner" wrote in message
...
I'm not very Visual Basic saavy. Is there a command you can use by mouse?
"TPenner" wrote:
I am trying to run a macro to pull info. off different spreadsheets and
put it into the last row (accumulating info. daily) of a spreadsheet, but
the macro is giving the row absolute cell reference, instead of relative.
Example: It is putting the new info. in row 742 every day instead of today
742, tomorrow 743, etc.
Thanks for any help!!!
Tim
|