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.