+ Reply to Thread
Results 1 to 2 of 2

Runtime error 32809 -> No solution on the web

  1. #1
    Registered User
    Join Date
    01-16-2015
    Location
    SLO
    MS-Off Ver
    2013
    Posts
    1

    Runtime error 32809 -> No solution on the web

    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.

  2. #2
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Canada Eh
    MS-Off Ver
    Excel 2010
    Posts
    199

    Re: Runtime error 32809 -> No solution on the web

    Can you post the code? It's difficult to help fix code that we cannot see.
    Click the * to give Rep to a post you like.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Runtime error 32809
    By hinta in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-14-2015, 09:24 AM
  2. Working Code Suddenly Broken: Run-Time Error '32809'
    By Tirren in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 11-03-2014, 04:36 AM
  3. Missing references - Unable to remove and get runtime error 32809 and
    By wazimu13 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-29-2014, 08:33 AM
  4. Macro to unprotect and protect a workbook - error 32809
    By erlend9 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-22-2013, 03:20 AM
  5. Error 32809 with ActiveSheet.Paste in Excel 1997
    By gjcase in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-27-2009, 02:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1