Reply
 
Thread Tools Display Modes
  #1   Report Post  
JSAB83
 
Posts: n/a
Default Determining Word Cell references

In a table with split columns, etc, how do you know what the cell reference
"name" is so that you can calculate values? Is there a view or option to
display this?
Thanks!
  #2   Report Post  
Suzanne S. Barnhill
 
Posts: n/a
Default

Get the TableCellHelper macro from
http://word.mvps.org/FAQs/AppErrors/...eIncorrect.htm. When run in a
table, it returns the address of the active cell, plus the total number of
rows and columns in the table.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"JSAB83" wrote in message
...
In a table with split columns, etc, how do you know what the cell

reference
"name" is so that you can calculate values? Is there a view or option to
display this?
Thanks!


  #3   Report Post  
Posted to microsoft.public.word.tables
ejp
 
Posts: n/a
Default Determining Word Cell references


JSAB83 wrote:
*In a table with split columns, etc, how do you know what the cell
reference
"name" is so that you can calculate values? Is there a view or option
to
display this?
Thanks! *


I believe I'm correct in saying that when you split a cell in a column
all columns to the right increase one letter. So when you split cell
b2, the resulting cells are b2 and c2 and the column formerly
identified as "c" is now column "d". This isn't a problem when the
formula is simple, such as =SUM(left) since the absolute references in
the formula are unaffected. Where the formula refers to specific cells
(e.g., =SUM(b2,f4)) you might have to go in and edit the formula to
refer to the correct cells.

For simple tables, I have found that adding a row (new row 1)at the top
and a column at the left (new column "a")before entering formulas and
inserting sequential letters and numbers, respectively, starting with
the second cell in the new column and the second cell of the new row,
allows you to enter formulas using the new cell references you've
created that way. When you're done editing your table, delete the added
row and column and the formulas will automatically refer to the correct
cells.
See the attached Word file that has a very rudimentary table that
illustrates this.


+----------------------------------------------------------------+
|Attachment filename: table with cell reference row and column.doc|
|Download attachment: http://www.mcse.ms/attachment.php?postid=6730799 |
+----------------------------------------------------------------+


--
ejp
------------------------------------------------------------------------
Posted via http://www.mcse.ms
------------------------------------------------------------------------
View this thread: http://www.mcse.ms/message1233883.html

Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
word xp crashes after macros are recorded kharris0405 Microsoft Word Help 3 January 11th 05 10:50 PM
WordPerfect - copying formatting Morgan Page Layout 1 January 10th 05 05:00 PM
WP Delay Code - Word Equiv Mike G - Milw, WI Microsoft Word Help 6 January 10th 05 04:12 PM
Continuous breaks convert to next page breaks Jennifer Hunt Microsoft Word Help 2 December 30th 04 05:45 PM
macro in word js Microsoft Word Help 1 December 28th 04 03:01 AM


All times are GMT +1. The time now is 06:51 AM.

Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"