Top "Excel-tables" questions

Questions dealing with structured (aka ListObject) tables in Excel-Formula and Excel-VBA.

How do I reference tables in Excel using VBA?

Is it possible in Excel VBA to reference a named table? Hypothetically this could be... Sheets("Sheet1").Table("A_Table").…

Read More
excel vba listobject excel-tables
Add/Modify/delete calculated column formula in Excel Listobject/Table via VBA

If I manually enter a formula into a column in an Excel table (i.e. ListObject), AutoCorrect applies this formula …

Read More
excel listobject excel-tables vba
VBA for selecting a number of columns in an excel table

As I learned here (also quoted in SO) the following code can be used to select the data-body of column 3 …

Read More
excel excel-tables vba
Combining IF and RIGHT functions in excel

I'm a super novice, trying to navigate data analysis in Excel, so be kind! I need to combine the IF …

Read More
excel-formula excel-tables
Dynamically expand an excel table based on entries in another table

I'm setting up a spreadsheet with the goal of allowing users to enter data by employee and date. I'd like …

Read More
excel dynamic excel-formula excel-2016 excel-tables