named cell in macro

P

Pa Maher

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.
 
J

Jim Thomlinson

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

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

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.
 
Top