+ Reply to Thread
Results 1 to 1 of 1

Screen fails to redraw (sheets overlapping) after executing a macro, errHandler problem?

  1. #1
    Registered User
    Join Date
    06-19-2015
    Location
    Bogota
    MS-Off Ver
    Officce 365
    Posts
    54

    Screen fails to redraw (sheets overlapping) after executing a macro, errHandler problem?

    Hi friends,

    I am almost there with my tool but it's not working properly. After I play the following macro the screen doesn't refresh properly when I change a cell. Just imagine that some parts of different sheets are showed overlapped in the active sheet.

    If I scroll down everything get back to normality until I again need to change a cell.

    Please Login or Register  to view this content.
    I am pretty sure there is an error in the execution because when line "On Error GoTo errHandler" was working before I commented but I don't know what it means or how to take advantage of it.

    Hope you can help me. It's the final issue I need to solve out.

    Many thanks. All the best,
    Geronimo

    ps: this is a split up of this post because it became too large to follow http://www.excelforum.com/excel-prog...ns-manual.html
    Last edited by gerotutu; 08-04-2015 at 08:04 AM.

+ 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. Macro fails to work across multiple sheets
    By nihargoel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2015, 08:15 AM
  2. Updating log on screen fails
    By jtable in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-26-2013, 06:06 AM
  3. renaming sheets macro fails
    By fatpiggy123 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-27-2010, 10:18 AM
  4. template macro executing problem the 2nd time
    By MAB in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2006, 08:10 AM
  5. Remove screen 'flicker' on executing code
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-07-2006, 04:35 AM
  6. Macro fails after screen is locked or screensaver becomes active
    By Denham in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-14-2005, 07:05 PM
  7. Problem executing a macro from different workbook where it is
    By Sergio Calleja in forum Excel General
    Replies: 1
    Last Post: 01-17-2005, 09:06 AM

Tags for this Thread

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