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