I am trying to put the following lines in a macro. If I replace the concatenation with a specific value (i.e. 9617) it works just fine. I don't understand why it is not working as listed. I get a Run-time error '1004': Method 'Range' of object_'Global' failed.
Any suggestions would be appreciated. I know I am missing something dumb.![]()
Selection.Copy Range("A3:A" & Str(sLastRow)).Select ActiveSheet.Paste
Thanks,
Dave
Bookmarks