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 |
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 |
All times are GMT +1. The time now is 01:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com