#1
|
|||
|
|||
When inserting row in table, how do I adjust cell reference to new row
I use a spreadsheet to track task time of chronologically successive tasks. The Start time cell in a given task row references the Stop time cell in the prior row, e.g., C6 (Start) = D5 (Stop).
When a new row is manually inserted between existing rows, in the row below it, the Start value should reference the Stop cell from the newly added row, e.g., C11 = D10. But the reference remains to the Stop value that is now above the new row, e.g., C11 = D9. I've tried to get this to work but haven't been successful, due to other macros in the spreadsheet, which I've attached. How can I get the Start cell below the newly added row to reference the Stop cell in the newly added row? |
#2
|
|||
|
|||
I solved this by re-applying the column's formula to the entire column when a row is added, which is detected via Worksheet_Change for a separate column.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reference Word Table Cell Using Offset? | wlcdo2 | Word VBA | 2 | 06-19-2016 08:53 PM |
how adjust cell width manually when table extends beyond paper margins? | dylansmith | Word | 1 | 11-06-2014 12:01 AM |
Inserting Images into a Table Cell without Moving the Text | suzan | Word | 0 | 06-27-2014 05:20 AM |
Inserting a date calculated from a table cell | theMikeD | Word | 2 | 09-11-2012 05:46 PM |
How do I reference a merged cell in a multi column & row table in MS Word ('03')? | jihanemo | Word Tables | 0 | 03-18-2009 08:33 AM |