Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use structured reference (ListColumns) in VBA
I want to do something simple...loop through a range retrieving values one at
time and taking action on that value. This range is an Excel 2007 table column. Easy enough...BUT I want to use structured references to a table column by NAME, not numbers. I don't want to define new names, just use the table column headings. I've found ways of doing it with quotes, but that's not structured....the names in quotes do not change if the table heading is changed by the user. The formulas change if the table column heading is changed, but I want it to change in VBA too. Can someone post a simple example that I can paste that will work? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
2007 Structured Reference auto-completion not working completely? | Excel Discussion (Misc queries) | |||
Structured reference question | Excel Programming | |||
Structured reference does not return correct value | Excel Worksheet Functions | |||
VLOOKUP with Structured Reference to Table Header | Excel Worksheet Functions | |||
Making a structured reference absolute? | Excel Worksheet Functions |