named cell in macro
 

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.

named cell in macro
 

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.

named cell in macro
 

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

In article ,
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.