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.