VBA question about selecting worksheets
On Apr 17, 10:17*am, Gary''s Student
wrote:
Sub Tryingsomething()
Sheets(Sheets("Sheet1").Range("A1").Value).Activat e
Range("A1").Select
End Sub
--
Gary''s Student - gsnu200779
Thanks,
this is eactly what I was looking for. I always seem to forget to
activate the sheet before selecting something on it.
Thanks again,
Jay
|