Hi, I’m think GetUsedRange() is working incorrectly.
Let’s say, I fill out the sheet by some data. I use GetUsedRange(), it returns A1:D10 range.
I delete the values in cells A3:D10. But when I call GetUsedRange() again, it still returns A1:D10, including A3:D10 cells with empty string. I thought it should return A1:D2 instead?
Is it a bug? Even if so, is there any temporary solutions to avoid that?
Hello @amogus
I believe this is expected behavior as sheet remembers all values and to “reset” this you need to run recalculation of the workbook or sheet. I will run some checks to share an example of macro that can do that.
Sorry for the delay. We have found an issue with recalculation when used range gets updated. This behavior was registered as a bug, we are already working on it.
Apologies for inconvenience.