Maybe
Private Sub Workbook_Open()
Sheets("Sheet1").Select 'change to your sheet
End Sub
Mike
"refina" wrote:
Hi Pls say me
1. How to mention a particular sheet name while opening excel with VB script.
2.how to know the rowcount and column count in excel using vb script.
as soon as possible .very urgent