Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Structured Table Refs in VBA
I'm confused about the relationship between tables (using structured
references) and ranges. I can work on individual cells from a table column, similar to working with a range, using- Dim oSh As Worksheet Set oSh = ActiveSheet Dim r As Range For Each r In oSh.Range("MyRange[ColumnName]") r.Value = 10 Next But if I try to create a range object from a table, using any of- r = oSh.Range("MyRange") r = oSh.Range("MyRange[#Data]") r = oSh.Range("MyRange[ rowvariable, [ColumnName]]") I think I am failing to see some basic principle here. I see lots of reference material on how structured table refs work in the Excel UI. Can someone point me to something simialr, or even just some working examples, for VBA code? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Structured Table Refs in VBA
I think you are simply missing the the Word Set before each object. Set is used when you want a variable equivalent to an object. without set it is simply setting your variable to the value (not object) of the object and not the object itself. from r = oSh.Range("MyRange") r = oSh.Range("MyRange[#Data]") r = oSh.Range("MyRange[ rowvariable, [ColumnName]]") to set r = oSh.Range("MyRange") set r = oSh.Range("MyRange[#Data]") set r = oSh.Range("MyRange[ rowvariable, [ColumnName]]") You code is simply returning the value from each of the loctions. The word Set says your variable r is equivalent to the object on the right side of the equal sign. -- joel ------------------------------------------------------------------------ joel's Profile: 229 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=186096 Excel Live Chat |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Structured references between worksheets | Excel Discussion (Misc queries) | |||
VLOOKUP with Structured Reference to Table Header | Excel Worksheet Functions | |||
convert multicolumn/multirow table into two structured/formatted columns = feasible? | Excel Programming | |||
Extract Client Refs from pivot table into another worksheet | Excel Worksheet Functions | |||
How do I select a value from a table based on 2 conditional refs? | Excel Worksheet Functions |