Thread: 2007 Table
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AP[_6_] AP[_6_] is offline
external usenet poster
 
Posts: 5
Default 2007 Table

On Oct 7, 6:30*am, dR wrote:
Excel 2007
How do you use structural reference to point to one cell: intersection
of certain column and certain row of a table (not #This Row)?
a. worksheet row
b. table row


Don't know what you mean bby "structural reference" and this may not
be what you're after, but to refering to a cell in your VBA code is
simple.

If for instance you wish to assign the value of cell B3 to a variable
called "cell_value", simply:

cell_value = Cells(3, 2).Value