Results 1 to 11 of 11

Paste Value Macro Yielding Blank Cells

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2014
    Location
    Houston, TX
    MS-Off Ver
    MS Office 2010
    Posts
    5

    Paste Value Macro Yielding Blank Cells

    Hello,

    So I have been working on a paste value macro and when I run it, every cell has the correctly pasted values except for one row. I have since isolated it to just writing a paste value macro for just that one row and it still comes up blank. Here is what I have written (It copies from one sheet to another in the same workbook):
    Sub Macro15()
    '
    ' Macro15 Macro
        Sheets("Bids1").Select
        Range("AJ21:AP21").Select
        Selection.Copy
        Sheets("Unit 1 Bids").Range("M143").PasteSpecial xlPasteValues
    End Sub
    Any ideas? Thanks.
    Last edited by Leith Ross; 10-27-2014 at 07:51 PM. Reason: Added Code Tags

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Yielding to others while macro is running?
    By vientito in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-20-2013, 02:14 PM
  2. [SOLVED] copy/paste macro to selected blank cells
    By fumc in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-04-2012, 10:08 PM
  3. Ignore, or display blank for cell yielding #DIV/0!
    By jgray in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-03-2010, 11:24 AM
  4. [SOLVED] Copy and paste macro-blank cells thereafter.
    By Bikernick in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-04-2006, 12:00 PM
  5. Using a Macro to paste into Blank Cells
    By phillipsb in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 10-05-2005, 01:05 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