So curious.
I have a sheet with a ton of hidden rows that i've hidden in VBA
If i want to add a few lines to that sheet. and do..
Then my VBA doesnt update .. I'm now hiding the wrong rows.
Is there a way to make VBA update ROW numbers.. if i add rows or delete rows on a sheet? A way to make vba recognize changes & automatically modify ? :/
I have a sheet with a ton of hidden rows that i've hidden in VBA
If i want to add a few lines to that sheet. and do..
Then my VBA doesnt update .. I'm now hiding the wrong rows.
Is there a way to make VBA update ROW numbers.. if i add rows or delete rows on a sheet? A way to make vba recognize changes & automatically modify ? :/