+ Reply to Thread
Results 1 to 2 of 2

Convert Formula to Macro Functions

  1. #1
    Registered User
    Join Date
    02-25-2014
    Location
    Turkey
    MS-Off Ver
    Excel 2010
    Posts
    77

    Convert Formula to Macro Functions

    Hi,
    l have two formula and l use in 351000 cells. For that excel is running slow. How can l make macro functions these formulas?

    First Formula:
    Please Login or Register  to view this content.
    G6 cell

    Second formula:
    Please Login or Register  to view this content.
    İf possible, l want to use this macro with function code as "=macro1(a;b;c;d;e)" in cells.

    Regards.
    Sorry my language.
    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert Ron Coderre's Avatar
    Join Date
    03-22-2005
    Location
    Boston, Massachusetts
    MS-Off Ver
    2013, 2016, O365
    Posts
    6,996

    Re: Convert Formula to Macro Functions

    User Defined Functions are always slower than the native Excel functions they try to replace.
    Here's a method I use when I have an huge volume of sluggish formulas that slow down workbook performance, but rarely need updating.
    • Store a copy of the formula(s) someplace in the workbook (I usually put them in a hidden row above the formula range)
    • Convert the slow formula range to values.

    When the formulas need updating, I run a macro that
    • Copies the template formulas into the formula range
    • Re-Calculates the workbook
    • Converts the formula range to values

    I hope that helps.
    Ron
    Former Microsoft MVP - Excel (2006 - 2015)
    Click here to see the Forum Rules

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. convert formula to macro.
    By superchew in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-05-2013, 08:31 PM
  2. Convert formula to a Macro
    By HangMan in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 12-17-2012, 08:04 AM
  3. convert macro into formula
    By busybeemg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2010, 02:45 PM
  4. Convert CSE formula to a macro
    By maacmaac in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-22-2009, 10:16 PM
  5. need macro: convert formula to value
    By moshe in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-06-2005, 12:06 PM

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