How to move worksheet into specific position?
Eric,
This can go in several events modules. Change Sheet1 to the name of the
desired sheet
Application.Goto Sheets("Sheet1").Range("I54"), scroll:=True
Private Sub Workbook_Open()
Private Sub Worksheet_Activate()
--
Mike
When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
"Eric" wrote:
Does anyone have any suggestions on how to move worksheet into specific
position? I would like to re-locate the worksheet (my sheet) into I45
position whenever I open it, so cell I45 will be the first row and column
within my sheet.
Does anyone have any suggestions on how to create a macro for my sheet?
Thanks in advance for any suggestions
Eric
|