ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   selecting columns in a worksheet (https://www.excelbanter.com/excel-worksheet-functions/64711-selecting-columns-worksheet.html)

nuti

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


Don Guillett

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