I don't have a next guess.

You may want to post a few more lines of code.

Foggy wrote:

On Thu, 01 Apr 2004 21:28:35 -0600, Dave Peterson
wrote:

Whenever I see the 1004 error with words that say it worked in xl2k, but not
xl97, I think of code being run from a control on the worksheet from the
ControlToolbox toolbar. (Like a commandbutton).

If that describes your situation, then try changing the .takefocusonclick
property of that control to False.

If the control you're using doesn't have that property, then add this line near
the top of your code:

activecell.activate

Thanks for this, but I have already tried it.
The problem occurs in two places.
Firstly in the Workbook_Open event and then later as a result of
comboboxes on the actual sheet.
Any further help is appreciated.

Foggy

--

Dave Peterson