resizing CurrentRegion to add 1 more column with the same formatting

[billyheanue]

Hi All,

I have a table that needs to expand to another column, and I know that cell "b3" is a part of that table.

I know that:

Range("B3").CurrentRegion.Select

will select the entire table, but how should I go about expanding it one more column?

Thanks a ton,
Bill

 

[timfritsch]

Try Range("B3").CurrentRegion.resize(,1).select


Tim

 

[billyheanue]

Thanks Tim!

 

[billyheanue]

Try Range("B3").CurrentRegion.resize(,1).select


Tim

I just tried adding this line, and it doesn't work - what I am looking for is something that will add a column to the edge of the table, regardless of whether or not "B3" is a cell in the last column or not. I thought since it is a cell within the table, the code would know to add a column at the *END* of the table, not to the column of cells ("C:C") that are already inside it.