Results 1 to 7 of 7

Copy formula value from one sheet and paste value only to another sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    04-30-2009
    Location
    USA
    MS-Off Ver
    Excel 2016
    Posts
    496

    Copy formula value from one sheet and paste value only to another sheet

    Hello all. Below is a snippet I need help with. I looked through the Forum and tried the suggestions as indicated below, but none of them work. The formula is located in cells on the ("Uniform Order Sheet") and I want only the VALUE copied and pasted to the ("UniformBuild") sheet. The suggestions popup various errors. I think it may just the position of the PASTE section if the line that is the issue but I have tried without success to move it.

    With Sheets("Uniform Order Sheet")
        .Range("AA" & Rw).Copy Sheets("UniformBuild").Range("T8").PasteSpecial xlValues
        .Range("AF" & Rw).Copy Sheets("UniformBuild").Range("T9").PasteSpecial Paste:=xlPasteValues
        .Range("AK" & Rw).Copy Sheets("UniformBuild").Range("T10").PasteSpecial xlPasteValues
        .Range("AP" & Rw).Copy Sheets("UniformBuild").Range("T11").Value = .Value
    End With
    Thanks,
    Andrew
    Last edited by drewship; 06-20-2013 at 09:29 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