Activating Only the Used Range : Worksheet Event « Excel « VBA / Excel / Access / Word
- VBA / Excel / Access / Word
- Excel
- Worksheet Event
Activating Only the Used Range
Private Sub Worksheet_Activate( )
Me.ScrollArea = Range(Me.UsedRange, Me.UsedRange(2,2)).Address
End Sub
Related examples in the same category