Copy paste special into last row of another worksheet
Solved/Closed
                                    
                        Roy                    
                                    -
                            Jun 17, 2016 at 05:53 AM
                        
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jun 27, 2016 at 09:42 AM
        TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor Last seen December 27, 2022 - Jun 27, 2016 at 09:42 AM
        Related:         
- Paste after last row vba
- Why cant i paste on instagram ✓ - Instagram Forum
- Saints row 2 cheats - Guide
- Vba case like - Guide
- Vba matrix multiplication - Excel Forum
- Excel online vba - Guide
2 responses
                
        
                    TrowaD
    
        
                    Posts
            
                
            2921
                
                            Registration date
            Sunday September 12, 2010
                            Status
            Contributor
                            Last seen
            December 27, 2022
            
            
                    555
    
    
                    
Jun 21, 2016 at 11:35 AM
    Jun 21, 2016 at 11:35 AM
                        
                            
                    Hi Roy,
Try this:
Worksheets("Allocation").Range("K9:Y262").copy Worksheets("WebADI").Range("C"&rows.count).end(xlup).offset(1,0)
When you want an empty row between pasted data change the offset to (2,0).
Best regards,
Trowa
 
                
                
            Try this:
Worksheets("Allocation").Range("K9:Y262").copy Worksheets("WebADI").Range("C"&rows.count).end(xlup).offset(1,0)
When you want an empty row between pasted data change the offset to (2,0).
Best regards,
Trowa
 
        
    
    
        
    
    
    
Jun 22, 2016 at 10:00 AM
thank you very much for your response its made a huge dent in what i am trying to do. It worked in regards to pasting the information over, however i will need to paste as values in order to stop all the formulas ref'ing out, can you please help me further in pasting the same code as values.
Thank you Roy