Results 1 to 5 of 5

VBA to copy formulas in column D and paste as values in same column

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,176

    VBA to copy formulas in column D and paste as values in same column

    I have create a formula in column D. Once the formula is created, I want to copy and paste as values. I am try to make the code more efficient by not having select the cells in the process. I've tried both methods below, but can't get either to work. Thanks

    Range("D2:D" & Lastrow).FormulaR1C1 = "=IF(LEFT(RC[8],3)=""TEN"",""RR-12"","""")"
    Range("D2:D" & Lastrow) = Range("D2:2" & Lastrow).Value
    Range("D2:D" & Lastrow).FormulaR1C1 = "=IF(LEFT(RC[8],3)=""TEN"",""RR-12"","""")"
    Columns("D:D").copy Destination:=Columns("D:D")Paste:=xlPasteValues
    Last edited by maacmaac; 01-09-2012 at 10:38 PM.

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