Sunday, March 11, 2012

Find The First Cell After Freeze Pane

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

No comments:

Post a Comment

Import data from SQL

Macro to import data from SQL using ADO connection string: Sub Import_data_from_SQL() ' Tools -> References -> Microsoft Active...