Excel 2003 - VBA - .copy

C

Craig Brandt

I want to copy a range from one page to another. I seem that I have to have
the sheet that I am copying from as the activesheet.

Sheets("Display").Select
Sheets("PPO").Range(Cells(3, 2), Cells(3, NumSym + 1)).Copy
Sheets("Param").Cells(3, 2).PasteSpecial Paste:=xlPasteValues,
Transpose:=True

The above will fail.

Sheets("PPO").Select
Sheets("PPO").Range(Cells(3, 2), Cells(3, NumSym + 1)).Copy
Sheets("Param").Cells(3, 2).PasteSpecial Paste:=xlPasteValues,
Transpose:=True

This will work.

Is there a way to do this without selecting either sheet. When this
procedure runs, the sheets are flickering back and forth and I would like to
change parameter and watch the results on the display sheet without all this
distraction.

Thanks,

Craig
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Need Help with a VBA subroutine 0
A simple if <> nn then Msgbox "No Match" 5
Having difficulty copying and pasting on VBA 3
Copy columns and paste with blank column between 5
Filename Problem In a Macro 4
What's wrong with my macro code? 0
Modify working code to expand the output. 5
Copy Data from One sheet to Different Sheets 1

Top