How do I add Paste values to this code?
Closed
Jan
-
Apr 4, 2010 at 08:49 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 5, 2010 at 12:22 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 5, 2010 at 12:22 AM
Related:
- How do I add Paste values to this code?
- How to get whatsapp verification code online - Guide
- Battery reset code - Guide
- Samsung volume increase code - Guide
- 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
- How to add @ in laptop - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Apr 5, 2010 at 12:22 AM
Apr 5, 2010 at 12:22 AM
I have not tested it but i think if you change this line
Rows(i).Copy Destination:=Sheets(2).Rows(j)
to
Rows(i).Copy
Sheets(2).Select
Cells(j, "A").Select
ActiveSheet.PasteSpecial xlValues
Rows(i).Copy Destination:=Sheets(2).Rows(j)
to
Rows(i).Copy
Sheets(2).Select
Cells(j, "A").Select
ActiveSheet.PasteSpecial xlValues