+ Reply to Thread
Results 1 to 2 of 2

Display formulas in a worksheet vba adjustment help

  1. #1
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Display formulas in a worksheet vba adjustment help

    I found this code on Contextures website to find all the formula in a workbook and display on mirrored pages, but in a workbook of 40 worksheets, after about the fourth worksheet is runs extremely slow. So what I would like to do is change the code and manually run it for every worksheet. You think I can get it working?? Here is the code pretty well as found on the Contextures website. Thanks for any help!
    Please Login or Register  to view this content.

  2. #2
    Forum Contributor
    Join Date
    08-22-2009
    Location
    Manitoba
    MS-Off Ver
    Office 2010
    Posts
    524

    Re: Display formulas in a worksheet vba adjustment help

    Well, I deleted the four sheets that took forever to do and what a difference! It completed the rest of the workbook in no time! Hmmm, something in them first four pages is really slowing down excel, which is why I get "not responding" quite often now! Could be the "paste link" I tried??

+ 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. Display rounding adjustment before getting the end result
    By fandy123 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 02-03-2016, 03:23 PM
  2. Replies: 7
    Last Post: 07-16-2012, 04:25 PM
  3. worksheet shows dates as number and formulas as formulas
    By baneVader in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2008, 01:36 PM
  4. How do I display and print formulas in a worksheet?
    By rklemenhag in forum Excel General
    Replies: 1
    Last Post: 07-28-2006, 02:10 PM
  5. All formulas display zero....HELP!!!
    By Drew Pruitt in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2005, 07:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1