Results 1 to 3 of 3

Paste Special issue with Macro

Threaded View

  1. #1
    Registered User
    Join Date
    10-03-2007
    Location
    Twin Cities, MN
    MS-Off Ver
    2003
    Posts
    83

    Paste Special issue with Macro

    Sub MMC_Hole()
    'Add MMC HOLE to report - 01-07-2009 by Mike Shadick
        
        Sheets("Formulas").Range("B2:K7").Copy
        Sheets("Data30 - Dev").Select
        ActiveCell.Offset(0, 0).Select
        ActiveSheet.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone, SkipBlanks:= _
            True, Transpose:=False
        ActiveCell.Offset(6, 0).Select
    End Sub
    I am trying to use the above code to copy data from one sheet and paste special/skip blanks on a second sheet. I want all the formatting and formulas, but I want to skip the blank cells so it does not replace the data I have already entered. For some reason, I keep getting an error and the debugger highlights the Activesheet.Pastespecial part of the code. What am I doing wrong here?
    Last edited by pingwin77; 04-14-2011 at 03:58 PM.

Thread Information

Users Browsing this Thread

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

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