Is anyone else fed up with this error? Today's lovely contestant is (as seen in the debug window)
?range("CurPlan"
which is a single cell which was created by Insert/Name/Define.
While the macro is not running, ?range("CurPlan" gives the correct contents.
As soon as I single-step one line into any macro, ?range("CurPlan" gives the P.O.S. error. Of course, if my code contains range("CurPlan", Program Go Boom.
Now the awesome beauty is that I also have a range - also just one cell - called iAge, that never chokes on Range("iAge". Why does CurPlan choke and not iAge?
Neither of the 2 cells is on the Active sheet.
Beyond explaining the error message, is this the proper way to reference a named range variable? I need the contents to do a Print #1, after some specialized formatting manipulation.
TIA
?range("CurPlan"
which is a single cell which was created by Insert/Name/Define.
While the macro is not running, ?range("CurPlan"
gives the correct contents.As soon as I single-step one line into any macro, ?range("CurPlan"
gives the P.O.S. error. Of course, if my code contains range("CurPlan", Program Go Boom.Now the awesome beauty is that I also have a range - also just one cell - called iAge, that never chokes on Range("iAge"
. Why does CurPlan choke and not iAge?Neither of the 2 cells is on the Active sheet.
Beyond explaining the error message, is this the proper way to reference a named range variable? I need the contents to do a Print #1, after some specialized formatting manipulation.
TIA
