I would appreciate help with VBA that I could use to select the top left hand cell in a pane (my worksheet has frozen panes).
I have tried the following, however this does not deal with the situation where the first column in the pane is hidden. So if the pane starts at column G, but columns G - J are hidden I would like the selection to be made with respect to column K. Using the VBA below the selection is made in column G.
.ScrollRow = 1
.ScrollColumn = 1
Call Cells(RowIndex:=.ScrollRow, ColumnIndex:=.ScrollColumn).Select
Many thanks in advance