Results 1 to 5 of 5

Find * Column A and Paste Special Values

Threaded View

Racer Find * Column A and Paste... 03-10-2010, 01:41 AM
MarMo Re: Find * Column A and Paste... 03-10-2010, 04:42 AM
rwgrietveld Re: Find * Column A and Paste... 03-10-2010, 05:01 AM
Racer Re: Find * Column A and Paste... 03-11-2010, 07:28 PM
Racer Re: Find * Column A and Paste... 03-11-2010, 07:28 PM
  1. #1
    Registered User
    Join Date
    03-07-2010
    Location
    Buena Vista, Virginia
    MS-Off Ver
    Excel 2003
    Posts
    6

    Find * Column A and Paste Special Values

    I am trying to scan every row in Column A for this symbol * , when this symbol * is found I’d like the macro to copy the row and perform a paste special / values for the row that the * was found in.

    This is what I have so far but I am kind of stuck, if you could lend a hand i would appreciate the help. Thanks

    Range("A?:A?").Copy
    Range("A?:A?").PasteSpecial Paste:=xlPasteValues, _
    Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    End With
    Application.CutCopyMode = False
    Application.ScreenUpdating = True
    Last edited by Racer; 03-11-2010 at 07:26 PM. Reason: SOLVED

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