Excel VisualBasic Script

  1. Home
  2. VisualBasic Script
  3. Excel
  4. Activating Only the Used Range
Private Sub Worksheet_Activate( )
      Me.ScrollArea = Range(Me.UsedRange, Me.UsedRange(2,2)).Address
End Sub