+ Reply to Thread
Results 1 to 3 of 3

adjust macro for paste formulas to values

  1. 11-11-2021, 08:51 AM #1
    ste33uk
    ste33uk is offline
    Registered User
    Join Date
    01-27-2020
    Location
    england
    MS-Off Ver
    office 365, excel version 1912
    Posts
    53

    adjust macro for paste formulas to values

    Hi could someone please adjust this macro so that is would paste formulas to values for columns "AS to AV"
    Currentlly it only changes formulas to values for column "AR"
    Thanks

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  2. 11-11-2021, 09:21 AM #2
    Artik
    Artik is offline
    Forum Expert
    Join Date
    08-17-2007
    Location
    Poland
    Posts
    2,260

    Re: adjust macro for paste formulas to values

    Try 
    Please Login or Register  to view this content.
    Artik
    Reply With QuoteRegister To Reply
  3. 11-11-2021, 10:02 AM #3
    ste33uk
    ste33uk is offline
    Registered User
    Join Date
    01-27-2020
    Location
    england
    MS-Off Ver
    office 365, excel version 1912
    Posts
    53

    Re: adjust macro for paste formulas to values

    Thanks alot, that works
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formulas - Paste as Values Macro
    By burcha22 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-17-2017, 10:55 AM
  2. [SOLVED] Modify Macro to Paste Values instead of formulas
    By ruthieag in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-19-2017, 05:42 PM
  3. [SOLVED] simple macro -- looking to paste values, not formulas
    By clout90265 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-10-2014, 02:34 PM
  4. Macro to paste formulas, but not values
    By simple? in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 08-27-2013, 03:14 PM
  5. [SOLVED] Macro to paste formulas then paste values
    By deanstein in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-19-2013, 11:30 AM
  6. [SOLVED] How to cut and paste cells without having to adjust the formulas
    By Stephanie_117 in forum Excel General
    Replies: 3
    Last Post: 03-31-2012, 11:31 AM
  7. Macro to Copy Paste Values and Formulas
    By thillis in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-19-2009, 11:55 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1