ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   2007 Table (https://www.excelbanter.com/excel-programming/443708-2007-table.html)

dR

2007 Table
 
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

AP[_6_]

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


All times are GMT +1. The time now is 03:35 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com