How do I add Paste values to this code?
Closed
Jan
-
4 Apr 2010 à 20:49
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 5 Apr 2010 à 00:22
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 5 Apr 2010 à 00:22
Related:
- How do I add Paste values to this code?
- How to add at the rate in laptop - Guide
- How to add authorized user t mobile - Guide
- How to add keywords to youtube channel - Guide
- Microsoft save as pdf or xps add-in - Download - Other
- Cs 1.6 code - Guide
1 response
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
5 Apr 2010 à 00:22
5 Apr 2010 à 00:22
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