Results 1 to 8 of 8

For next loop and paste special Help please

Threaded View

  1. #1
    Forum Contributor
    Join Date
    12-31-2004
    Posts
    160

    Question For next loop and paste special Help please

    This sub works Thanks to Mr Ron de Bruin
    But I need to preserve the destination worksheet formating How do I modify this ?


    Dim cell As Range
    On Error Resume Next
    For Each cell In Sheets("Source").Range("E:E").SpecialCells(xlCellTypeConstants)
    If Application.WorksheetFunction.CountIf(Sheets("destination").Range("E:E"), cell.Value) > 0 Then
    'do nothing
    Else
    Sheets("Source").Range("A" & cell.Row & ":M" & cell.Row).Copy Sheets("destination").Cells(LastRow(Sheets("destination")) + 1, 1)
    End If

    Next cell


    I need to use paste special xlvalues I think
    but how?

    Thanks
    Charles
    Last edited by mrdata; 04-11-2006 at 08:33 PM. Reason: New Title

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