+ Reply to Thread
Results 1 to 2 of 2

VBA to convert formulas to value

  1. 12-09-2015, 04:59 AM #1
    talkvinith
    talkvinith is offline
    Registered User
    Join Date
    07-15-2014
    Location
    Mumbai
    MS-Off Ver
    2003
    Posts
    35

    VBA to convert formulas to value

    Hi

    Could any one please help me in creating a VBA for converting formulas to value of any entire row if a certain criteria matches.


    For example: In the attached sheet I want to covert the formulas of an entire row if the "Status" in D column in "Complete".

    Thank you!!
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 12-09-2015, 10:57 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,944

    Re: VBA to convert formulas to value

    Could I ask why you want to do this?
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    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. [SOLVED] Convert a group of formulas to array formulas at once
    By coach.32 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-16-2015, 02:21 AM
  2. need to convert text to formulas
    By jago in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-13-2015, 02:40 PM
  3. Convert Formulas into VBA
    By timmyjc18 in forum Excel General
    Replies: 3
    Last Post: 06-20-2012, 07:40 PM
  4. convert formulas into VBA
    By clausule in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-26-2011, 09:29 AM
  5. Convert formulas in text into formulas
    By Tau in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 12-13-2007, 08:31 AM
  6. How to convert 1 500 to 1,500 to use in formulas
    By dstock in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-21-2007, 09:50 AM
  7. I get my formulas like this RC[-1]*R[-2]C[6] how could I convert .
    By nperl in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-12-2005, 03:06 AM

Tags for this Thread

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