Select Columns from Seletced Cell Range on Excel 2010 with VBA
Posted on 2012-09-07
Let's say I have cells C3 to T3 selected as a result of VBA code that selects the DataRange on a PivotTable (code below). How would I then translate this to select all columns between C and T please (so that I can autofit them)?
The above code just selects a range of cells, so I would like to take this range and apply it to all columns within the same range please.