Without seeing any code it is tough to comment but in general you want
something like this

Workbooks("Worbook1").sheets("Sheet1").Range("MyRa ngeName").Copy
--
HTH...

Jim Thomlinson


"Pa Maher" wrote:

I posted this question earlier & it got posted in Excel for MACs, I am using
a PC

Currently in a macro, I copy a cell from Workbook A into Workbook B by
specifying the worksheet and cell ID.
The cell is named. I have tried using the cell name but it's not working.