Using VBA, I resort a range of cells by clicking on a column header.
After I have resorted based on a different column, the cells that are
visible are sometimes different. I was trying to find some code that
would record the upper-left-most cell into a variable, then return that
cell to the same upper-left-most corner, without changing the cell that
I have currently selected. Is this possible?

Thanks,

Carroll Rinehart

One thing I want to add. I have the column headers frozen on row 6, so
that everything from row 7 on is scrollable. I don't know if this adds
to the complexity.

Carroll

Dim toprow as Long
toprow = ActiveWindows.Pane(2).ScrollRow.row


then

ActiveWindow.Pane(2).ScrollRow = toprow

--
Regards,
Tom Ogilvy

"Carroll" wrote in message
ups.com...
One thing I want to add. I have the column headers frozen on row 6, so
that everything from row 7 on is scrollable. I don't know if this adds
to the complexity.

Carroll

Thanks Tom. BTW, I am using Excel 2002.

After I have added the 3 lines of code, when it hits "toprow =
ActiveWindows.Pane(2).ScrollRow.Row", I get this error: "Run-time error
424. Object Required."

Carroll

Sorry, that was a typo I though I had corrected before posting. it should
be

toprow = ActiveWindows.Pane(2).ScrollRow

--
Regards,
Tom Ogilvy

"Carroll" wrote in message
oups.com...
Thanks Tom. BTW, I am using Excel 2002.

After I have added the 3 lines of code, when it hits "toprow =
ActiveWindows.Pane(2).ScrollRow.Row", I get this error: "Run-time error
424. Object Required."

Carroll

Tom,

I'm still getting the same error after removing ".row" from the end.
Also, I notice that this line shows "ActiveWindows" and the last line
of code provided shows "ActiveWindow" (without the s). I tried it both
ways and got an error either way.

Carroll