View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Rick Rothstein Rick Rothstein is offline
external usenet poster
 
Posts: 5,934
Default moving active cell on another sheet

The ActiveCell and/or Selection only applies to the active sheet. Exactly
why do you want to do this? If you really need the active cell at a certain
point on a specific sheet when the sheet is made active, you could use the
sheet's Activate event to do that selection (but I'm thinking you are asking
this question for a different reason, hence my question to you above).

--
Rick (MVP - Excel)


"sunilpatel" wrote in message
...
Is it possible to change position of activecell on another sheet.

Tried the obvious! - whilst on "Sheet1"

Sub movecell()
Sheets("Sheet2").Range("a1").Select
End Sub