View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
tianung[_2_] tianung[_2_] is offline
external usenet poster
 
Posts: 1
Default 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