PC Review


Reply
 
 
dR
Guest
Posts: n/a
 
      6th Oct 2010
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
 
Reply With Quote
 
 
 
 
AP
Guest
Posts: n/a
 
      7th Oct 2010
On Oct 7, 6:30*am, dR <dov...@gmail.com> 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 With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Want to setup a Table of contents from text in a Table - Word 2007 Es Microsoft Word Document Management 1 22nd Jan 2010 01:06 PM
importing table contents from Word 2007 into Access 2007 andgenerating queries, reports using Access 2007 g_1 Microsoft Word Document Management 3 12th Nov 2009 06:58 AM
Word 2007 tables - dragging row in a table seems to damage table Ian Hill Microsoft Word New Users 2 20th Apr 2009 12:53 PM
Excel 2007 Macro specific table to generic table? Sue Microsoft Excel Misc 3 1st Jun 2008 06:12 PM
insert Access 2007 database table into a Word 2007 doc and print =?Utf-8?B?TGVlZGVsbA==?= Microsoft Word Document Management 0 20th Oct 2007 08:10 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:48 PM.