Results 1 to 4 of 4

need correction in code

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-21-2010
    Location
    Budapest
    MS-Off Ver
    Excel 2010
    Posts
    155

    need correction in code

    I have a macro created by someone which I should modify to copy the VALUE not the formula.
    Please help me to modify the line to copy and paste only the VALUE.

    Code.Offset(0, 6).Copy wsR.Range("F" & NR, "F" & BR)
    
    If LR > 1 Then
                    wsD.Range("A2:E" & LR).Copy wsR.Range("A" & NR)
                    BR = wsR.Range("E" & wsR.Rows.Count).End(xlUp).Row
                    Code.Offset(0, 6).Copy wsR.Range("F" & NR, "F" & BR)
                    NR = BR + 1
    End If
    Last edited by ccsmith; 05-04-2012 at 06:14 AM.

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