Copy values to multiple destinations
This does what I want between 2 workbooks in XL2K:
Range("RCATTND.XLS!C57:G57").Copy
Range("B4").PasteSpecial xlPasteValues
Range("G4").PasteSpecial xlPasteValues
Range("L4").PasteSpecial xlPasteValues
Range("Q4").PasteSpecial xlPasteValues
Range("V4").PasteSpecial xlPasteValues
Application.CutCopyMode = False
I would like to combine all pasting to a single step or loop, preferably
without final paste showing anything highlighted when finished.
--
David
|