Results 1 to 3 of 3

Copy range after find date paste value

Threaded View

  1. #1
    Valued Forum Contributor marreco's Avatar
    Join Date
    07-02-2011
    Location
    Brazil
    MS-Off Ver
    Excel 2010
    Posts
    1,862

    Copy range after find date paste value

    Hi
    I need find based A1 (criteria date), in range ("E1:XFD1") and paste below

    Sub CopyRangeToFindedDate()
        Dim MyDateCrit As Date, cfind As Range
        Dim rngCrit As Range
        
        Set rngCrit = Range("C2:D100")
        
        With Worksheets("Plan1")
            MyDateCrit = .Range("A1").Value
            rngCrit.Copy
                Set cfind = .Range("E1:XFD1").Find(what:=CDate(MyDateCrit), lookat:=xlWhole)
                If Not cfind Is Nothing Then
                    rngCrit.PasteSpecial xlPasteAll
                    rngCrit.Offset(2, 0).PasteSpecial xlPasteValues
                End If
            End With
        Application.CutCopyMode = False
    End Sub
    Attached Files Attached Files
    "No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.

    If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Find Text - Copy Range Below - Paste to Cell
    By keen2xl in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-02-2014, 05:39 AM
  2. how to copy a range of cells, paste them and then find next empty cell
    By comp23 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2013, 03:34 PM
  3. [SOLVED] Find the date and copy the values from the colum of the date find and paste to other sheet
    By nizzcmzph in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-20-2013, 10:03 AM
  4. [SOLVED] Macro to Find, copy, paste, find, copy, paste, find, copy, paste, u get the picture....
    By westsoldman in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-12-2012, 01:12 AM
  5. find date in column A and copy, paste and transpose valuse
    By myguess21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-31-2012, 03:24 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