named cell in macro

[Guest]

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.

 

[Guest]

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

Workbooks("Worbook1").sheets("Sheet1").Range("MyRangeName").Copy

 

[JE McGimpsey]

The answer isn't any different for Mac XL (not MAC) than for Windows XL.
See the answer in m.p.mac.office.excel.