+ Reply to Thread
Results 1 to 4 of 4

Activating multiple formulas

  1. #1
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2003
    Posts
    11

    Activating multiple formulas

    Hi!
    I have formulas/links in table B3:AE33, I would need to activate the formulas/links, but to do that I need to go in every cell and press enter.
    Is it possible to activate all formulas/links at the same time?
    Attached Files Attached Files

  2. #2
    Forum Guru xladept's Avatar
    Join Date
    04-14-2012
    Location
    Pasadena, California
    MS-Off Ver
    Excel 2003,2010
    Posts
    12,378

    Re: Activating multiple formulas

    Have you tried hitting F9?
    If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)

    You can't do one thing. XLAdept

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Activating multiple formulas

    HI Martinians,

    I have some VBA code that needs to go in a Module. Run this code and it will convert all those text equations to real formulas. It looks like:

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by MarvinP; 02-13-2015 at 08:39 PM.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  4. #4
    Registered User
    Join Date
    05-16-2014
    MS-Off Ver
    Excel 2003
    Posts
    11

    Re: Activating multiple formulas

    Thanks for the code..

+ 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. Activating Multiple Array Formulas at Once...
    By pipsturbo in forum Excel Formulas & Functions
    Replies: 32
    Last Post: 05-30-2014, 03:14 AM
  2. Activating/De-Activating Comments or only if the Cell is Active.
    By e4excel in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-31-2011, 11:08 AM
  3. Activating Multiple Web Links At Once
    By RalphSE in forum Excel General
    Replies: 0
    Last Post: 08-18-2006, 10:02 AM
  4. Fill down formulas without activating the sheet
    By Mark Stephens in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2005, 07:05 PM
  5. [SOLVED] Activating sheets with same name in multiple workbooks
    By Barb Reinhardt in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-26-2005, 01:05 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