+ Reply to Thread
Results 1 to 3 of 3

include = in formula

  1. #1
    Forum Contributor
    Join Date
    06-11-2018
    Location
    Lebanon, NH
    MS-Off Ver
    2000 and 2010
    Posts
    104

    include = in formula

    Good afternoon!
    I have a macro that pulls all the formulas in a workbook and pastes them into a separate worksheet. I'm running a macro on that worksheet to get a materials pick list.
    The macro to pull all the formulas is something I found on the web and it works great except for the fact that it doesn't include the = at the beginning of the formula. I'm a long way from a VBA expert (A Really long way!) and I am not sure just how to modify this macro to show the = in the formulas. I'm hoping someone can tell me what I have to change to do this. I'm guessing it is in the statement
    Please Login or Register  to view this content.
    in the macro. I would appreciate any input or suggestions.
    Thanks much
    Bill
    Macro attached
    Please Login or Register  to view this content.

  2. #2
    Forum Expert Tsjallie's Avatar
    Join Date
    09-15-2012
    Location
    NL
    MS-Off Ver
    2010, 2013, 2016
    Posts
    2,019

    Re: include = in formula

    Just change
    Please Login or Register  to view this content.
    into
    Please Login or Register  to view this content.
    But that will make the formula executed. If you want to prevent the formula from executing use
    Please Login or Register  to view this content.
    Cheers!
    Tsjallie




    --------
    If your problem is solved, pls mark the thread SOLVED (see Thread Tools in the menu above). Thank you!

    If you think design is an expensive waste of time, try doing without ...

  3. #3
    Forum Contributor
    Join Date
    06-11-2018
    Location
    Lebanon, NH
    MS-Off Ver
    2000 and 2010
    Posts
    104

    Re: include = in formula

    Thank you Tsjallie! I do want the formula to execute so this is perfect!
    Thanks
    Bill

+ Reply to Thread

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