Copy/pasting visible rows using macro?
Closed
krock
-
Apr 17, 2010 at 12:42 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 17, 2010 at 05:57 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 17, 2010 at 05:57 AM
Related:
- Root directory is full or error in pasting
- Network error occurred - Guide
- Cmos checksum error - Guide
- Phpmyadmin access denied for user 'root'@'localhost' - Guide
- Ps3 error 80023017 - PS3 & PS4 Forum
- King root - Download - Cleaning and optimization
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 17, 2010 at 05:57 AM
Apr 17, 2010 at 05:57 AM
Depends where you are pasting. If you intentionally pasting over it, of course it will be wiped out. Since you want to do it in a running manner, before you paste next time, you need to know where you ended last time
lmaxrows =sheets("my running total").cells(rows.count, "A").end(xlup).row
will give you last used row in column A
Also when you copy, copy from 2nd row and down, else you would be pasting header every time too.
lmaxrows =sheets("my running total").cells(rows.count, "A").end(xlup).row
will give you last used row in column A
Also when you copy, copy from 2nd row and down, else you would be pasting header every time too.
