way to make vba references update when rows added onto sheet?

[aedctalk]

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 ? :/

 

[GlennUK]

Make your row areas for hiding be named ranges, and use those in your VBA.