close

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,
nutidoes this help?

Sub selectcols()
With Sheets(quot;sheet1quot;)
..Select
..Range(quot;a1,c1,f1quot;).EntireColumn.Select
End With
End Sub

--
Don Guillett
SalesAid Software

quot;nutiquot; gt; wrote in message oups.com...
gt; hi folks,
gt;
gt; i need to take input for my script from an excel sheet .
gt; the excel sheet has 8 worksheets and i want to select particular
gt; columns from a particular worksheet.
gt;
gt; please help me out in this regard.
gt;
gt; cheers,
gt; nuti
gt;

全站熱搜
創作者介紹
創作者 software 的頭像
software

software

software 發表在 痞客邦 留言(0) 人氣()

E-mail轉寄