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

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - How to mention a particular sheet name while opening excel with VB script. (https://www.excelbanter.com/new-users-excel/191262-how-mention-particular-sheet-name-while-opening-excel-vbulletin-script.html)

refina

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

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

Mike H

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

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

Karthi Ganesh

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

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

"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

All times are GMT +1. The time now is 07:02 AM.