Macro stopped working

  • Thread starter Thread starter s boak
  • Start date Start date
S

s boak

Hi Folks:
I have a workbook set up with a macro to record samples.
This morning the macro just stopped sending data to the database and an
error dialog comes up:
If I hit debug, I get:

For Each dd In Sheets("SI Sample").DropDowns
dd.Value = 1 (preceeded by yellow arrow)

Any help appreciated.
Should I post all code ??

Thanks
Steve
 
My first thought was that you had the linked cell locked on a protected sheet.

But I tried that in xl2002 and xl2002 didn't seem to care. I could change the
value in the dropdown, but the linked cell stayed the same.

Any chance your version is more picky?

If that wasn't it, what kind of error do you get?
 
Back
Top