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