I posted a similar question yesterday and got no takers. With wb1 and wb2 open, wb2 is active, I want vb code to place a named cell from wb1 into A1 of wb2. I found a way that works (below) but I'm sure it's not the cleanest approach.
Windows("wb1.xls").Activate
mycell = ActiveWorkbook.Sheets("SDA").Range("mycell")
Windows("wb2.xls").Activate
ActiveWorkbook.Sheets("Unpaid").Range("A1") = mycell
Windows("wb1.xls").Activate
mycell = ActiveWorkbook.Sheets("SDA").Range("mycell")
Windows("wb2.xls").Activate
ActiveWorkbook.Sheets("Unpaid").Range("A1") = mycell