+ Reply to Thread
Results 1 to 1 of 1

Slow running macro when cells are hidden

  1. #1
    Registered User
    Join Date
    12-14-2012
    Location
    USA
    MS-Off Ver
    Excel 2011
    Posts
    2

    Slow running macro when cells are hidden

    I've got a macro that runs fine if cells are not hidden & considerably slower when they are hidden. In normal operation I would like the cells that are the source of copying & destination of pasting to be hidden. The only cells that are not hidden are a1:d6. The overall application slows a bit, but this macro is the worst. Any ideas on how to speed it up? I appreciate any help. Here's the code:

    Sub clicksave2()
    ActiveSheet.unprotect
    Application.ScreenUpdating = False
    If Range("a63") = 1 Then
    Range("a63") = 2
    Range("b38:u38").Select
    Selection.Copy
    Range("b63:u63").Select
    Selection.PasteSpecial Paste:=xlValues
    Range("a1").Select
    Application.CutCopyMode = False
    Else
    Range("a63") = 1
    Range("b63:u63").Select
    Selection.ClearContents
    Range("a1").Select
    Application.CutCopyMode = False
    End If
    Application.ScreenUpdating = True
    ActiveSheet.protect DrawingObjects:=True, Contents:=True, Scenarios:=True
    End Sub
    Last edited by bhsoundman; 12-18-2012 at 02:42 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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