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?
 - 2007 microsoft office add-in microsoft save as pdf or xps - Download - Other
 - Cs 1.6 code - Guide
 - How to add @ in laptop - Guide
 - How to add songs to sound picker - Guide
 - How do i add keywords to my youtube channel - 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