If you want to use a couple of macros, you can do it.

Option Explicit
Dim CurActCellAddr As String
Private Sub Workbook_Open()
CurActCellAddr = ActiveCell.Address
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If CurActCellAddr = "" Then
'do nothing
Else
With Application
.EnableEvents = False
.Goto Sh.Range(CurActCellAddr)
.EnableEvents = True
End With
End If
CurActCellAddr = ActiveCell.Address
End Sub
Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, _
ByVal Target As Range)
CurActCellAddr = ActiveCell.Address
End Sub

rightclick on the excel icon to the left of the File|edit|view (on the worksheet
menubar).
select view code and paste this in.

Then try it out.

The first time the address gets initialized is with the workbook open event. If
you test without closing/reopening your workbook, it may take one selection
change to "prime the pump."




trees1021 wrote:

Hi, Denise and I have been trying to figure this out together. Is there a way
to move from one sheet to another sheet and remain in the same cell as in
Lotus? Excel always reverts to cell A1 or the cell where you left off when
previously on that sheet.

Gail

"Dave Peterson" wrote:

Maybe....

What's a Global Group?

Denise S wrote:

Can I work in Global Group in Excel?

--

Dave Peterson


--

Dave Peterson