Results 1 to 8 of 8

Code no longer Working, Error 91

Threaded View

  1. 02-14-2018, 12:15 AM #8
    yujin
    yujin is offline
    Forum Contributor
    Join Date
    01-03-2018
    Location
    Fukuoka, Japan
    MS-Off Ver
    Excel 2013
    Posts
    123

    Re: Code no longer Working, Error 91

    Glad it worked.

    Now I wonder why it used to work if that code was never there?
    The Automatic Calculation is set to be "ON" by default but it can be accidentally turned off. By selecting Formulas ribbon and choose Calculation Options, you can change the setting.

    What does Me.Calculate do?
    "Me" is equivalent to "This Worksheet", so "Me.Calculate" recalculates the formulas of the sheet even if Auto Calculation is set to be "OFF".
    Last edited by yujin; 02-14-2018 at 12:22 AM.
    Reply With QuoteRegister To Reply
« 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. Code to hide rows is no longer working
    By NancyPez in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-12-2016, 11:36 AM
  2. PasteSpecial in VBA Code No Longer Working
    By kmsandrbs in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-06-2014, 01:27 PM
  3. VB Code no longer working
    By buttercup1227 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-06-2014, 10:38 AM
  4. [SOLVED] Private sub code no longer working (print area macro)
    By rikkyshh in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-09-2013, 10:43 AM
  5. [SOLVED] Code stopped working, can no longer copy and save a worksheet
    By Oracle in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-30-2012, 07:56 PM
  6. VBA Code no longer working
    By jdbel in forum Excel General
    Replies: 16
    Last Post: 11-16-2011, 07:33 PM
  7. mail Code no longer working in 2007
    By lonnied in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-10-2007, 06:14 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1