Selecting a range with variables

[ebetke]

One of our key data sources is a cube. I connect to the cubeto pull data into a pivot table and then clean up the table so that it is in table format. I want to copy the table and paste it to another tab as values then run through the clean up of the headers and first two columns. Since the tables vary in size, I want to use variables for the range selection. Selct down to last row and last column. I cannot figure it out. I used the recorder to get most of the other code and just need help identifying the ranges to be modified. Here is what I recorded and this is the piece I want to be variable - Range("A10:C271").Select.


Range("C10").Select
Range(Selection, Selection.End(xlDown)).Select
Range("A10:C271").Select
Range("C10").Activate
Selection.SpecialCells(xlCellTypeBlanks).Select
Application.CutCopyMode = False
Selection.FormulaR1C1 = "=R[-1]C"

Thanks for your help!

 

[cjcobra]

Start at the top right side of the pivot table (so it will select all the way down, and not hit any blanks).

Range(ActiveCell, ActiveCell.End(xlDown)).Select

Then move to the left until you select the entire table.

 

[ebetke]

Ok I will give that a try.