Bob,

I can see that my reply could have been worded a little better.

Please note the use of "Rows.Count" in my reply.
65535 to go <vbg

John

"Bob Phillips" wrote in message
...
Scott,

"scott jeremy" wrote in message
...

John,
Actually i dont want it to go to the last blank row. What i was hoping
for is to find the first row that is blank so that it pastes in
descending order just below the last row that already has data.


John's code actually gives you the first blank row after your data, not
the
last.



Im new to macros... would i take the code you showed me and just create
a macro that starts :
Sub 'macroname()

-
-code
-
end sub

Yes, or include it in the existing macro.