PDA

View Full Version : Copy and Paste Values To Another Sheet Without Showing The Switch When Run



gaff123
12-20-2007, 04:21 AM
Hi
Please help if you can.
I have been trying to set up a macro that copies a value in one sheet and pastes it into a cell in another sheet but when I run the macro the switch between the sheets is shown and it looks very unprofessional. Does anyone have any ideas. I don't have to copy and paste it I just want the value from one cell to be put into another on a different sheet but they can't be linked.

Many Thanks

Gaff

PaSha
12-20-2007, 04:59 AM
why can't they be linked?

rory
12-20-2007, 05:35 AM
You can use code like:
Workbooks("blah.xls").Worksheets("Sheet1").Range("A1").Value = Workbooks("source.xls").Worksheets("Sheet1").Range("A1").Value
rather than doing a copy and paste (though you can do that too without actually switching sheets visibly.)