Get selected cell on sheet that is not the active sheet
On Dec 18, 1:49*am, joel wrote:
I can't seem to get the address of the selected cell that is not on the
activesheet. *Anybody know how to do this in 2003?
Let's say you have a sheet named "Sheet3" and you want the E4 cell in
this sheet to have the text "Joel". This can be achieved as follows:
Sheets("Sheet3").Cells(4, 5).Value = "Joel"
HTH
|