+ Reply to Thread
Results 1 to 6 of 6

Debug Error

  1. #1
    Forum Contributor
    Join Date
    07-21-2013
    Location
    washington dc
    MS-Off Ver
    365 MSO
    Posts
    473

    Debug Error

    HI,

    I am receiving a debugging error beg. .range any ideas? Thanks

    Please Login or Register  to view this content.

  2. #2
    Forum Expert
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,454

    Re: Debug Error

    Please Login or Register  to view this content.
    Last edited by AB33; 07-09-2015 at 05:02 PM.

  3. #3
    Registered User
    Join Date
    07-09-2015
    Location
    Monterrey,Mexico
    MS-Off Ver
    excel 2013
    Posts
    3

    Re: Debug Error

    same problem
    Range("D4:AA495").Select
    Selection.Copy
    Workbooks.Open Filename:="d:\Miguel Azar\Documents\seguros\AAAACliente.xlsm"
    Sheets("resumen cliente").Select
    Range("a5").Select
    ActiveSheet.Paste (paste dont work , it was working fine a few day ago for few years , run-time error 1004: paste method of worksheet failed)

  4. #4
    Registered User
    Join Date
    07-09-2015
    Location
    Monterrey,Mexico
    MS-Off Ver
    excel 2013
    Posts
    3

    Re: Debug Error

    Quote Originally Posted by Mazar View Post
    same problem
    Range("D4:AA495").Select
    Selection.Copy
    Workbooks.Open Filename:="d:\Miguel Azar\Documents\seguros\AAAACliente.xlsm"
    Sheets("resumen cliente").Select
    Range("a5").Select
    ActiveSheet.Paste (paste dont work , it was working fine a few day ago for few years , run-time error 1004: paste method of worksheet failed)
    i have the same macro in an older file ,works perfect, seams the problem is in onedrive storage that corrupt the macro)

  5. #5
    Registered User
    Join Date
    07-09-2015
    Location
    Monterrey,Mexico
    MS-Off Ver
    excel 2013
    Posts
    3

    Re: Debug Error

    seams the macro is corrupt ( in my case the onedrive storage seams to be the problem corrupting the macro)
    i solve wit a back copy of my file) renaming editing etc not work

  6. #6
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,689

    Re: Debug Error

    Mazar,
    1. Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

    If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

    2. Don't quote whole posts -- it's just clutter. If you are responding to a post out of sequence, limit quoted content to a few relevant lines that makes clear to whom and what you are responding.
    Ben Van Johnson

+ 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. VBA Code Runs in Debug Mode But Returns Type Mismatch Error Outside Debug Mode
    By valerie.k.chiang in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2014, 03:48 PM
  2. [SOLVED] debug error
    By rickmeister in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 10-29-2013, 09:09 AM
  3. Debug error 13
    By BillGoodman in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 06-23-2009, 03:12 PM
  4. debug error?
    By mitelkm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-18-2008, 01:27 PM
  5. [SOLVED] down with the debug error
    By hurlbut777 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2005, 09:06 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