Results 1 to 3 of 3
  1. #1
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts

    Convert Formula to Value and copy values

    I have a formula in Col V & W from row2 onwards

    I need VBA code to do the folllowing

    1) I need the formula in Columns V & W from row 2 to the last row containing data to be converted into values
    2) I need the values in Col V from row 2 onwards to be copied into T2
    3) I need the values in Col W from row 2 onwards to be copied into U2


    Your assistance in this regard is appreciated

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    How about this:

    Code:
    Sub CopyPasteVW()
      Range(Cells(2, 22), Cells(Rows.Count, 22).End(xlUp)).Copy
      Range("V2").PasteSpecial xlPasteValues
      Range("T2").PasteSpecial xlPasteValues
      Range(Cells(2, 23), Cells(Rows.Count, 23).End(xlUp)).Copy
      Range("W2").PasteSpecial xlPasteValues
      Range("U2").PasteSpecial xlPasteValues
    End Sub
    Steve
    Last edited by sdckapr; 2012-07-28 at 11:55.

  3. #3
    Bronze Lounger
    Join Date
    Feb 2008
    Posts
    1,420
    Thanks
    124
    Thanked 5 Times in 5 Posts
    Hi Steve

    Thanks for the help, much appreciated

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •