Problem with Run Time Error 1004

[lotusman]

Hope someone can help me with a macro that's just stopping, displaying the 1004 error message, plus the text:
"This formula is missing a range reference or a defined name".
The macro's 1st line is to go to a named range. Then it stops, just before a line which has the command to clear the contents. There's no protection in place, with cells locked. The range name happens to be "ComboListBB" - is that name problematic in some way? A similar macro I have goes to a range called "ComboListB", no problems there. The range contains various values, and can be selected 'manually' no problem. Thanks for any hints.

[Richard Buttrey]

What's the actual line of code that's highlighted in yellow when the Debug message box pops up?
Better still upload the workbook so that we can see the problem in context.

[lotusman]

What's the actual line of code that's highlighted in yellow when the Debug message box pops up?
Better still upload the workbook so that we can see the problem in context.

It was the usual Goto.Reference: "..." (Using my phone, have not got the bva to hand...). Hope that is sufficient info, thanks.

[lotusman]

It was the usual Goto.Reference: "..." (Using my phone, have not got the bva to hand...). Hope that is sufficient info, thanks.

Actually, I've solved it. I made a copy of a spreadsheet page. That page had 6 named ranges. Now the copy of that page had 6 more ranges with the same names, located in 'parallel' areas. I changed the six new names, adding B to each one, e.g. CellChoice became CellChoiceB. I had a macro doing something with CellChoice. I copied it and edited it so that it handled the new ranges, on the new page. However, it seemed to think a new range had not been properly defined, and it would not function. Instead, I deleted the new range names, and recreated them 'manually'. Macros now work with these 'proper' ranges. That was it.
Lotusman

[Richard Buttrey]

Don't forget its's perfectly possible to have the same range name on different sheets.
The default scope for a named range is the workbook but if you want to limit the scope to a particular worksheet then yuo need to incorporate the sheet name in the range name definition.

[lotusman]

Don't forget its's perfectly possible to have the same range name on different sheets.
The default scope for a named range is the workbook but if you want to limit the scope to a particular worksheet then yuo need to incorporate the sheet name in the range name definition.

Thanks, Richard, I'll check that out.