Scrolling selected cell to top left position of unfrozen pane

[looknsee]

I have a big honkin' spreadsheet. By selecting Cell D7 and using the "Freeze Panes" command, I have ensured that the left 3 columns and the top 6 rows will always be on the screen. The rest of the spreadsheet is for data entry, and there can be hundreds of rows & columns.

I have successfully created some macros that allow me to select the next cell for data entry, but when I do that, the selected cell can appear anywhere in the "unfrozen" area.

What I would like is some VB code that will place the selected cell in the top left corner of the "unfrozen" area -- in other words, it should be in the cell that is below the column headers and to the right of the row headers. Note: the column widths, row heights, and overall zoom factor might differ, so I can't exactly hard code anything other than the number of rows and columns in the headers.

Thanks in advance.

 

[Jaafar Tribak]

Welcome to MrExcel

Try :

Application.Goto Selection, True

 

[looknsee]

Yes, that works. Don't know why it works, but I'll accept the incantation to the Excel gods.
Thanks.