LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
2007 Structured Reference auto-completion not working completely? SVanDee Excel Discussion (Misc queries) 0 February 20th 10 01:01 AM
Structured reference question Barb Reinhardt Excel Programming 0 September 3rd 09 02:29 PM
Structured reference does not return correct value vsoler Excel Worksheet Functions 5 July 19th 09 05:15 PM
VLOOKUP with Structured Reference to Table Header Julien Bouvier Excel Worksheet Functions 4 December 18th 08 11:34 PM
Making a structured reference absolute? Ted M H Excel Worksheet Functions 5 April 14th 08 04:13 AM


All times are GMT +1. The time now is 02:26 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"