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!

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!

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