|Subject:||Excel VBA error|
|Posted by:||R Ormerod|
|Date:||Wed, 22 Aug 2007|
I receive the following error message when closing an Excel file when one of
its unhidden worksheets is active, but not the other:
Run-time error '1004'
Select method of Range class failed
Debug points to code in a Private Sub (not in the Module) relating to one of
several combo boxes in the first worksheet, as follows:
Private Sub ComboBox2_Change()
The LinkedCell for each combo box is a cell in the same worksheet, which in
turn feeds into a formula in the second worksheet (and I think this is where
Excel seems to be getting confused).
The ListFillRange for the combo boxes is located in a hidden worksheet.
If the Active Sheet is the forst worksheet, however, the file can be saved /
closed without any errors, so I tried this code:
But this did not work.