How to mention a particular sheet name while opening excel with VB script.

R

refina

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
 
M

Mike H

Maybe


Private Sub Workbook_Open()
Sheets("Sheet1").Select 'change to your sheet
End Sub

Mike
 
K

Karthi Ganesh

U can use usedrange.column.count and usedrange.rows.count
regards
Karthiganesh
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to mention a particular sheet name while opening excel with VB script. 1
to represent sheet 1
Copying data into new text file with script 0
Merging from an Excel file with graphics 1
Consistent Sheet column header rows 2
VB/Excel query 1
simple vb script to open, 0
Excel Macro VBA to Count Google Search Results 0

Top