Thread
:
Saving ActiveCell coordinates
View Single Post
#
2
Posted to microsoft.public.excel.programming
Mike Fogleman
external usenet poster
Posts: 1,092
Saving ActiveCell coordinates
Sub ActCell()
Dim c
c = ActiveCell.Address
End Sub
Cheers... Mike F
"James Duncan" <James
wrote in message
...
Hi there,
I haven't performed any programming for years and I have a memory blank on
how to resolve this easy issue.
I need to save the current ActiveCell coordinates of the cursor so that I
can programmatically jump back to this cell at some later stage.
I need the code to save the current cell position and also the code to
jump
back to this position. I know it involves copying the cell info to
variable(s) and using Range to jump but all my attempts have failed :(
Thanks
James
Reply With Quote
Mike Fogleman
View Public Profile
Find all posts by Mike Fogleman