Copy and Paste Values To Another Sheet Without Showing The Switch When Run

[gaff123]

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]

why can't they be linked?

[rory]

You can use code like:
[VBA]Workbooks("blah.xls").Worksheets("Sheet1").Range("A1").Value = Workbooks("source.xls").Worksheets("Sheet1").Range("A1").Value[/VBA]
rather than doing a copy and paste (though you can do that too without actually switching sheets visibly.)