Didn't want to sound over-dramatic, but two lines of code that have been working perfectly for months seem to have acquired a problem.

The lines in question are these:
Set ComboRange = ClassSheet.Columns(ComboCol)
Set BoxRange = ComboRange.Find(cboName, LookIn:=xlValues)
To explain the context, ClassSheet is a worksheet name "Config", which is the current ActiveSheet. ComboCol is a string constant "J".
cboName is a string variable containg "cboOrderClass". This value is located in cell J3 of the Config sheet.

The intent is first to set up a searchable column (J) (the first line), and then to find the place, in that column, where cboOrderClass is found (the second line), and create a range (BoxRange) at that address..

This has been working well for ages, and is a part of my toolbox to store ComboBox values in a configuration Worksheet.

The first line works exactly as intended. In the debugger I can examine any of the attributes of range ComboBox, and they are returned, most importantly the address, which is returned as "$J:$J".

The second line returns the dreaded Run-time error '1004' - Application-defined or object-defined error.

Of course, this aborts the program, so I can't see which object is causing the problem. However, I've just used ClassSheet to set up ComboRange, so ComboBox should survive the transition from one line to the next, right? Also, I can't see if BoxRange is really not being set - even though the value I'm looking for is iin cell J3, which is certainly part of column J.

As I said, this has been working well for months, and now, all of a sudden the ComboRange seems to disappear. (I'm assuming that this is the object where the error is occurring. One known cause of this trying to access a range on an inactive sheet, but the ActiveSheet is Config (shown by Debug) - and we have to access the sheet to create COmboBox (which works) so that should not be the problem.

I'm black and blue from beating my head against a wall - can any one provide balm for my soul (and my ego), and give me a hint?

Thanks,

Tony

I can send the spreadsheet, but these are just two lines of code in several hundred (within the application).