Copy/pasting visible rows using macro?
Closed
krock
-
Apr 17, 2010 at 12:42 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 17, 2010 at 05:57 AM
rizvisa1 Posts 4479 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?
- Your account is not visible to people on facebook, and you can't use it. - Facebook Forum
- To protect you, your profile is not visible to people on facebook and you can't use your account. - Facebook Forum
- Root directory is full or error in pasting - Android Forum
- Make passwords visible - Guide
- Macro copy and paste in next blank cell - Guide
1 reply
rizvisa1
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
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.