Showing posts with label Find The First Cell After Freeze Pane. Show all posts
Showing posts with label Find The First Cell After Freeze Pane. Show all posts

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

Import data from SQL

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