| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
selecting columns in a worksheet
hi folks,
i need to take input for my script from an excel sheet . the excel sheet has 8 worksheets and i want to select particular columns from a particular worksheet. please help me out in this regard. cheers, nuti |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
selecting columns in a worksheet
does this help?
Sub selectcols() With Sheets("sheet1") ..Select ..Range("a1,c1,f1").EntireColumn.Select End With End Sub -- Don Guillett SalesAid Software "nuti" wrote in message oups.com... hi folks, i need to take input for my script from an excel sheet . the excel sheet has 8 worksheets and i want to select particular columns from a particular worksheet. please help me out in this regard. cheers, nuti |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How dio you flip a worksheet that the columns start on the right | Excel Discussion (Misc queries) | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| How do I copy a link that is in columns to another worksheet down. | Excel Discussion (Misc queries) | |||
| columns and rows on my worksheet will not stay resized | Excel Worksheet Functions | |||
| How can i set consecutive columns in an excel worksheet to differ. | Charts and Charting in Excel | |||
Linear Mode
