View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default address of activecell in another sheet

Thanks! I was not specific enough, I hoped that there is a simpler way than
that. I'm satisfied because there is not an additional lack of my knowledge.
Stefi


€˛Gary''s Student€¯ ezt Ć*rta:

Sub get_it()
Set whereami = ActiveSheet
Sheets("Sheet2").Activate
MsgBox (ActiveCell.Address)
whereami.Activate
End Sub

--
Gary''s Student - gsnu200771