Copying Cells Using A Macro

[Tubtech]

Is there a way using a macro to copy cells, for example cells F8,F10,F12,F14 in workbook 1 to cells A2:A5 in workbook 2?

i have been trying...

x.Sheets(strSourceSheetName).Range("F8").Copy
y.Sheets(strDestinationShetName).Range("A1").PasteSpecial

It appears to work with a single cell being copied but no more than that...

Any help will be appreciated...Thanks!

[Kaper]

Try:

Please Login or Register  to view this content.

make sure cells (copied from and to) are not merged

[Tubtech]

Thanks my friend that worked like a charm ....!!!!!