worksheet

C

cojo

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.
 
F

Frank Kabel

Hi
AFAIK there's no such shortcut

--
Regards
Frank Kabel
Frankfurt, Germany

cojo said:
I have a user who is trying to move from worksheet to worksheet but
Click to expand...
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.
 
J

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
 
Top