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 errors during pasting
- Kingo root - Download - Customization
- Game vault apk download android no root - Download - Online gaming and betting
- How to change download directory opera gx - Guide
- Chrome extension directory - Guide
- Batch copy directory ✓ - Programming Forum
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.
