If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
WP Delay Code - Word Equiv | Mike G - Milw, WI | General Discussion | 6 | January 10th, 2005 04:12 PM |
macro in word | js | General Discussion | 1 | December 28th, 2004 03:01 AM |
Macro that will add the file path & date to Word footnotes? | Rich P | General Discussion | 2 | December 15th, 2004 07:49 PM |
saving the workspace | Mike | General Discussion | 3 | December 8th, 2004 11:32 PM |
IF E3 & E10 = TRUE set this cell to "Yes", else set to "No" | Timothy L | Worksheet Functions | 5 | August 27th, 2004 02:28 AM |