I have three named ranges in Column B.
The range data is always numbers.
I am using =OFFSET('Sheet1'!$B3,0,0,COUNTA(Sheet1!!$B3:$B24),-1) to define
Range BFP
I am using =OFFSET('Sheet1'!$B35,0,0,COUNTA(Sheet1!!$B35:$B44 ),-1) to define
Range OHAC
I am using =OFFSET('Sheet1'!$B50,0,0,COUNTA(Sheet1!!$B50:$B65 ),-1) to define
Range MSE
My problem is that when I insert a new row in say the BFP range, the OHAC &
MSE range kept the same starting rows and were off by one row. I removed the
$ in from of the row numbers, but then it added like 10 more rows to the
range.

How do I fix this so that when I add a row in any of the ranges, all the
ranges will stay correct?
Each of the ranges does have a label in Column A one row before the range
actually starts. These will always be one row above the starting range of
numbers. Maybe do a search for the label and start the range one row below?
But then how to end the range? I can create the range in VBA if you have
suggestions? Thanks again!

Thanks!