Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.
Forums » Excel Forums » VBA » Error Message

Error Message

Previous | Next
Latest post Thu, Jun 24 2010 1:33 PM by Jim Cone. 1 replies.

  • Thu, Jun 24 2010 10:34 AM

    • baron77
    • Top 25 Contributor
    • Joined on Fri, Aug 8 2008
    • Posts 64
    • Points 1,099

    Error Message

    Reply |Contact

    Hi All,

    I'm utilising a macro (keystrokes) in Excel '07 which works perfectly.

    A colleague, who uses '03 has tried to run the macro but is getting this error:

    Run-time error '1004'

    Method 'Range' of object'_Global'failed

    What can I do so that both '03 & '07 users can run this without problem.

    Many thanks
    • Post Points: 21

  • Thu, Jun 24 2010 1:33 PM In reply to

    • Jim Cone
    • Top 10 Contributor
    • Joined on Tue, Jan 15 2008
    • Portland, Oregon - USA
    • Posts 130
    • Points 1,830

    Re: Error Message

    Reply |Contact |Mark as Answer

     

    You should post the macro code and indicate the line where the error occurs.
    '--
    Jim Cone
    Portland, Oregon USA
    Excel add-ins/workbooks
    • Post Points: 5
Page 1 of 1 (2 items) | RSS
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.