If you want to know the first cell after the freeze pane . Try this code-
Sub address_of_first_cell_after_freezepane()
With ActiveWindow
If .SplitRow = 0 And .SplitColumn = 0 Then
MsgBox "No freeze Pane Found"
Else
MsgBox Cells(.SplitRow + 1, .SplitColumn + 1).Address
End If
End With
End Sub
Sub address_of_first_cell_after_freezepane()
With ActiveWindow
If .SplitRow = 0 And .SplitColumn = 0 Then
MsgBox "No freeze Pane Found"
Else
MsgBox Cells(.SplitRow + 1, .SplitColumn + 1).Address
End If
End With
End Sub
No comments:
Post a Comment