Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 returns data as 2007 table instead of range - how to turn off. | Excel Programming | |||
Excel 2007 pivot table source table | Excel Discussion (Misc queries) | |||
Update Access 2007 Table Using Excel 2007 VBA | Excel Programming | |||
Excel 2007 Macro specific table to generic table? | Excel Discussion (Misc queries) | |||
Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) |