Hey Matt
Definitely; named ranges are nice and much more dynamic.
I am now trying to figure out how to get to each row or cell in a named range.
Also,
If you name a range Sh1bills
With this bit of code:
Sub Sh1bills()
Set rng1 = Range("Sh1bills")
Set rng1 = rng1.Resize(rng1.Rows.Count + 1)
MsgBox rng1.Rows.Count
You can have the msgbox return the number of rows in the range.
If you insert or delete a row in the range and run the macro again, it will return the new row count.
This is a good start but I need a way to say, if row is inserted or deleted, then
Do something
Any ideas?
Also, would you put that in the change event?
Thank you,
Mark