vb script + excel - select multiple columns
I am trying to set the autofilter property on for a group of
I guess this is done using:
excel_app.Selection.AutoFilter = True
The problem is with the selection of columns. The left top cell (E6) is
known but the right top cell has to be 10th from right (same row)
So, I have been trying code like:
excel_app.Range(Sheet.Cells(E, 6), Sheet.Cells(x, 6)).Select filling x
with different things, none of which seem to work.
Can anyone here suggest how to do this?
I am new to this, so kindly explain in terms of the following
Set excel_app = CreateObject("Excel.Application")
Set excel_wbk = excel_app.Workbooks.Open(fileName)
Set excel_wks = excel_wbk.Sheets(1)
Set pivotTable = excel_wks.PivotTables(1)
Thanks in advance for the help.