Discussion on:

Message 12 of 22
0 Votes
+ -
Simple VBA - Good intro for a new user as well
Private Sub Worksheet_Activate() ' This Sub-Macro runs on Actvating the Sheet

' Note Macros need to be enabled on entering the worksheet

Range("C3").Select ' Selects the specified cell using the Range Method

End Sub ' Finished with VBA and returned back to Excel
Posted by DublinAl
7th Feb 2012