At the beginning and I stopped getting the error message.
I am just wondering though, because no other cells have formula that are dependent on B6. However there are some that are dependent thru their conditional formatting. But change in formatting does not constitute a worksheet_change event as far as I know...
rr should be declared as Long anyway, but in any case I tried your code and it works for me without errors. Something else must be going on in your worksheet or maybe some conflicting code. CF should have no bearing on the problem. I cannot duplicate your error.
Changing a cell creates a change event so you enter an infinite loop when you change cells during change events. The error message doesn't really make sense but the fact that there is an error is expected. In short, with Excel you have to disable events to change cells during change events.