Hellou,

I have huge difficulties with the famous error 32809. I scoured the web for solution and found that none were working, so you are my only hope

Circumstances:
I started writing a complex code in VBA on my office computer 2003 version. Then i got, from the much hated IT expert, 2013 version. And then all hell went loose.
After rewriting bits of code it all started working...for a time.

AT first it worked on my office (2013) and in my bosses office (2010), but not some other network computer, which also has 2013 office.
After updating the non working office 2013 computer it started working there.
Now it doesn't work in on my bosses 2010 version.

I get the famous 32809 error.
  • Tried with the debugger, error just "flips" to another code section...now it cannot read a cell.value from a sheet.. WTF
  • Tried updating his office...no avail.
  • ActiveX buttons stopped working, new (form control) are now working.
  • Tried deleting the excell file in /appData/roaming.... that forum users suggested. (after 14.dec 2014 MS update...thx billy)
  • Tried countless, previosly working version..... none of them works now.

Checked references in VBA...not exactly the same as in version 2013 but that is to be expected.. Same checboxes are checked though.

I suspected that a worksheet is corrupted (because the code did not want to read values from named and unnamed ranges), so i copied the sheet to another workbook. When I tried to delete the old sheet it CRASHED!

So I thought that maybe it is a corrupted file. So I opened (my comp) another file and copied everything, and also copied code. When I opened in 2010 again, the same effect.

I am wondering in the dark here, so any suggestions?

Have a nice day.