When inserting row in table, how do I adjust cell reference to new row

		Microsoft Office Forums > Microsoft Excel > Excel Programming
When inserting row in table, how do I adjust cell reference to new row

FAQ

Thread Tools

Display Modes

01-16-2022, 01:06 PM

Peterson

Windows 10 When inserting row in table, how do I adjust cell reference to new row

Office 2019

Competent Performer

Join Date: Jan 2017

Posts: 143

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.

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:28 PM.