Link to home
Start Free TrialLog in
Avatar of tommym121
tommym121Flag for Canada

asked on

reference another worksheet

I am using VBA to manipulate two worksheet1 and worksheet2.
If my worksheet2 is active now and I need to execute the following code on worksheet1 how do I write it in VBA?

   Rows("14:14").Select
    Application.CutCopyMode = False
    Selection.Copy
    Rows("16:16").Select
    ActiveSheet.Paste

ASKER CERTIFIED SOLUTION
Avatar of Dave
Dave
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tommym121

ASKER

Thanks.