| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| problem while opening the excel sheet | New Users to Excel | |||
| problem while opening the excel sheet | New Users to Excel | |||
| Opening Excel sheet in its own window | Setting up and Configuration of Excel | |||
| Opening A Specific Excel Sheet | Excel Discussion (Misc queries) | |||
| Opening an excel sheet but i don't see it | Excel Discussion (Misc queries) | |||
Linear Mode
