How to copy and paste

Closed

rey - May 25, 2010 at 09:31 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - May 26, 2010 at 02:41 AM

Hello,

I want to copy something from the 1st worksheet and paste to 2nd worksheet.
I have already the code but did not work.
What's wrong with this. can you correct this one?
Sub trans()
With Worksheets("English")
Range("B54:Q71").Select
Selection.Copy
End With

With Worksheets("French")
Range("B54").Select
ActiveSheet.Paste
End With

End Sub

How to copy and paste
How to paste photo in word - Guide
Pi copy and paste - Guide
Whatsapp web copy paste text not working ✓ - WhatsApp Forum
Compare two worksheets and paste differences to another sheet - excel vba free download ✓ - Excel Forum
Macro to compare two excel sheets ✓ - Excel Forum

1 response

Answer 1 / 1

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
May 26, 2010 at 02:41 AM

You are not activating the sheet. "WITH" is only a shortform but does not select sheet

sheets("English").Select
Range("B54:Q71").Select
Selection.Copy

Sheets("French").Select
Range("B54").Select
ActiveSheet.Paste

Similar discussions

Can no longer paste text into insta

Deleted Message icon

Comparing Two Excel Sheets and copying like data to third sheet

VBA Compare 2 sheets and output difference to 3rd sheet

Macro to compare 2 sheets and copy differences

Similar discussions

Subscribe To Our Newsletter!