worksheet

[Guest]

I have a user who is trying to move from worksheet to worksheet but wants the same cell in each worksheet. He heard that there is a shortcut but I'm not sure what he's talking about. Has anyone heard about this? I know how to move from worksheet to worksheet but not always getting to the same cell.

 

[Frank Kabel]

Hi
AFAIK there's no such shortcut

--
Regards
Frank Kabel
Frankfurt, Germany

I have a user who is trying to move from worksheet to worksheet but

wants the same cell in each worksheet. He heard that there is a
shortcut but I'm not sure what he's talking about. Has anyone heard
about this? I know how to move from worksheet to worksheet but not
always getting to the same cell.

 

[JE McGimpsey]

One way:

Tell the user to put this macro in their Personal.xls file and assign it
to a keyboard shortcut:


Public Sub NextSheetSameRange()
Dim sSelected As String
Dim sActiveCell As String
sSelected = Selection.Address
sActiveCell = ActiveCell.Address
With Worksheets
.Item(ActiveSheet.Index Mod .Count + 1).Activate
End With
ActiveSheet.Range(sSelected).Select
ActiveSheet.Range(sActiveCell).Activate
End Sub