Hi Ashish
what i exactly want is that for attendance record i using an excel
file which 12 pages for entry and 1 page for printing purpose. in the
sheet for printing i create a macro , its working well but every month
i have to change the selected sheet name January, February etc.
instead of this i
try this see if it helps
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 1 And Target.Column = 1 Then
On Error Resume Next
Sheets(Range("a1").Text).Activate
End If
End Sub
On Sun, Nov 28, 2010 at 5:32 PM, Rajesh K R wrote:
> Hi experts
>
> How can i select a sheet from fil
