Using a table column in VBA code

[JimDandy]

I have a table that, when data is added to it, expands the number of rows to accommodate the size of the data. In Column G is a formula that references Column E. If I change the formula in the first cell of the column, that formula is copied down correctly and when adding rows this formula is properly added to the new rows but I also allow this column to be edited if needed which, of course, removes the formula.

So I have created a macro that can be executed to reset the formulas in that column back to the starting point. Initially, my VBA code was written to upgrade each of the initial rows but if I add rows, this code stops at the last original row. So, the question is, can I use the table name/column name in a VBA formula so that I can use one line of VBA code that correctly resets the formulas in all rows, new and old?

The formula is: =IF(E17="""","""",$AV$35)
The Table name/Column name is: UnitData[Floorplan Data]

In the data above, E17 should increment to E18, etc.

[AlphaFrog]

Try something like this...

Please Login or Register  to view this content.

The VBA Guide To ListObject Excel Tables

[JimDandy]

Works great!

Thank you...

[AlphaFrog]

You're welcome. Thanks for the feedback.