copy cell range from one workbook to another

[ronaldmacdonald]

Hi

This may be a simple question but how can I copy a cell range from one open workbook to another open workbook.
Eg Ive opened workbook "a" and workbook "b" and want to copy the cell range a1:a10 from "a" to "b".

Cheers

Ronald

 

[RobBroekhuis]

Try:

workbooks("a.xls&quot.sheets(1).range("A1:A10&quot.copy workbooks("b.xls&quot.sheets(1).range("A1&quot
Rob

 

[ronaldmacdonald]

Thanks Rob, thats worked fine.

Im creating a monster...

Ronald