+ Reply to Thread
Results 1 to 5 of 5

Application-defined or object-defined error

  1. #1
    Registered User
    Join Date
    10-07-2014
    Location
    Norfolk, England
    MS-Off Ver
    2013
    Posts
    29

    Application-defined or object-defined error

    Hi guys,

    Having an issue with an order form I have created. It works fine for the majority of users, but two have a run-time error ('32809') when trying to use one of the macros.

    The particular macro simply pastes a cell to another cell on a different sheet in the workbook, but it fails at this point.

    I have googled the error, but I couldn't find a resolution that worked for these two users. Interestingly, they both have exactly the same model of PC (Fujitsu), which differ from the rest of the team.

    I have attached some images which show exactly where the macro fails, there are multiple macros in the workbook that work absolutely fine.

    Any help is greatly appreciated, thank you.

    Drewan
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Application-defined or object-defined error

    Try adding:

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-07-2014
    Location
    Norfolk, England
    MS-Off Ver
    2013
    Posts
    29

    Re: Application-defined or object-defined error

    Hi John,

    Thanks for the reply, still having the same issue unfortunately....

    Any other ideas?

    Drewan

  4. #4
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Application-defined or object-defined error

    Do you have a sheet names OrderForum or is there a space?

  5. #5
    Registered User
    Join Date
    10-07-2014
    Location
    Norfolk, England
    MS-Off Ver
    2013
    Posts
    29

    Re: Application-defined or object-defined error

    Definitely named "OrderForm", and the macro works absolutely fine on everyone else's machine...

    So frustrating!

+ 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. Replies: 1
    Last Post: 05-08-2014, 04:57 AM
  2. [SOLVED] application-defined/object-defined error 1004 when trying to read from or write to cells
    By florin_excel in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-30-2012, 08:38 AM
  3. Replies: 2
    Last Post: 09-12-2012, 01:01 PM
  4. Application Defined or Object Defined Error, Command Button and Vlookup Function
    By stevedomer in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-14-2011, 11:20 PM
  5. Replies: 3
    Last Post: 07-24-2006, 08:20 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