LinkBack URL
About LinkBacks
you want to copy to the first empty cell (from the bottom) in column A which is done like this:
Sheets("Sheet2").Cells(Rows.Count,1).End(XlUp).Offset(1,0).PasteSpecial
you want to copy to the first empty cell (from the bottom) in column A which is done like this:
Sheets("Sheet2").Cells(Rows.Count,1).End(XlUp).Offset(1,0).PasteSpecial
Pierre Leclerc
_______________________________________________________
If you like the help you got,
Click on the STAR "Add reputation" icon at the bottom.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks