+ Reply to Thread
Results 1 to 4 of 4

Macro Formula not calculating over different Sheets and Workbooks

  1. #1
    Registered User
    Join Date
    06-19-2022
    Location
    Antarctica
    MS-Off Ver
    365
    Posts
    5

    Macro Formula not calculating over different Sheets and Workbooks

    Hi,
    I am currently using the below code to calculate number of conditionally formatted cells with dates in. I am needing to use this macro over three sheets in the workbook. It is currently only displaying data on one sheet at a time. If I have two books open at the same time running the same macro it will also only calculates on one sheet. I have no idea how to fix this and really hoping someone is able to help.

    I am needing the end user to be able to just enter a date and it will conditionally format and then be calculated but the macro automatically. this is Monitoring dates that have expired or in date.

    Please Login or Register  to view this content.

  2. #2
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Macro Formula not calculating over different Sheets and Workbooks

    How about
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    06-19-2022
    Location
    Antarctica
    MS-Off Ver
    365
    Posts
    5

    Re: Macro Formula not calculating over different Sheets and Workbooks

    Thank you Fluff13. I have replaced the previous code with the one you suggested but it has now come up with #VALUE! on all the cells it has been applied to. Any other suggestions? Your help is greatly appreciated.

  4. #4
    Forum Guru
    Join Date
    09-10-2017
    Location
    Chippenham, England
    MS-Off Ver
    365
    Posts
    15,027

    Re: Macro Formula not calculating over different Sheets and Workbooks

    Did you keep this function, or did you delete it
    Please Login or Register  to view this content.

+ 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. Macro to paste the sheets on different workbooks
    By viewotst in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-15-2021, 04:50 AM
  2. Sheets/Workbook Not Calculating after Macro run
    By Wheelie686 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-01-2020, 08:50 PM
  3. VBA/Macro to combine sheets from different workbooks
    By legend905 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-22-2018, 06:18 PM
  4. Macro to copy past sheets from different workbooks
    By Andre2016 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-29-2016, 10:27 AM
  5. [SOLVED] how to use macro (split sheets/tab) to all open workbooks
    By 2977cc in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-23-2015, 11:43 AM
  6. [SOLVED] Macro to Saving Workbook Sheets as Separate Macro-Enabled Workbooks
    By puppetpalace in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-03-2013, 01:58 PM
  7. Auto run macro on all workbooks/sheets
    By ww2u in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2007, 05:12 PM

Tags for this Thread

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