Forum Discussion
Solved
Excel code redirecting to first blank cell
I am using Microsoft® Excel® for Microsoft 365 MSO (Version 2109 Build 16.0.14430.20154) 32-bit. I have data in an Excel table which is being automatically populated line by line as users complete a ...
I guess formula reference on the next after the bottom of structured cell row. Since table is auto expandable Excel interpret such reference not as on cell address in, but as relative reference on next after the table cell. With expansion of cell it moves such reference.
In general with structured tables it's always better to use index for the reference on the cell, like
=IFERROR( INDEX(Table1[A], 10), 0)
I guess formula reference on the next after the bottom of structured cell row. Since table is auto expandable Excel interpret such reference not as on cell address in, but as relative reference on next after the table cell. With expansion of cell it moves such reference.
In general with structured tables it's always better to use index for the reference on the cell, like
=IFERROR( INDEX(Table1[A], 10), 0)- Aha! Yes it's the table changing. Thanks, worked it out now with table references, I think!
