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:
- Copy/pasting visible rows using macro?
- Make passwords visible - Guide
- Spell number in excel without macro - Guide
- Your account is not visible to people on facebook, and you can't use it. - Facebook Forum
- Macro excel download - Download - Spreadsheets
- Macro to insert row in excel based on criteria ✓ - Excel 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.