#1   Report Post  
Posted to microsoft.public.excel.programming
dR dR is offline
external usenet poster
 
Posts: 1
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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
Reply
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
Excel 2007 returns data as 2007 table instead of range - how to turn off. dflak Excel Programming 0 March 8th 10 02:57 AM
Excel 2007 pivot table source table sb Excel Discussion (Misc queries) 1 August 21st 09 12:18 AM
Update Access 2007 Table Using Excel 2007 VBA Sairam Excel Programming 0 November 14th 08 07:59 PM
Excel 2007 Macro specific table to generic table? Sue Excel Discussion (Misc queries) 3 June 1st 08 06:12 PM
Pivot Table in Excel 2007 : Problem with % in Table spudsnruf Excel Discussion (Misc queries) 2 January 9th 08 09:53 PM


All times are GMT +1. The time now is 10:38 PM.

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

About Us

"It's about Microsoft Excel"