Consulting

Results 1 to 4 of 4

Thread: Delete Sheet Macro Crashes Excel

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #3
    VBAX Mentor
    Joined
    Jan 2006
    Posts
    323
    Location
    Ok, so I think I found the cause, I have the following formulas in some cells on multiple sheets.

    =IF(OR(Incident_Start_Date="",Incident_Start_Date="MM/DD/YY"),"MM/DD/YY",ChangeDateFormat(Incident_Start_Date))
    
    =IF(Incident_Start_Time="HHMM","HHMM",Incident_Start_Time)
    
    =IF(OR((ISERR(ChangeDateFormat(Operational_Period_Begin_Date))),ISERR(ChangeDateFormat(Operational_Period_End_Date))), "MM/DD/YY HHMM - MM/DD/YY HHMM", ChangeDateFormat(Operational_Period_Begin_Date)& " " & Operational_Period_Begin_Time & " - " & ChangeDateFormat( Operational_Period_End_Date) & " " & Operational_Period_End_Time)
    Can anyone tell me why these formulas prevents the deletesheet macro form operating correctly?
    Is there a way to disable the sheet formulas first then invoke the deletesheet macro?


    Gary
    Last edited by zoom38; 04-11-2016 at 11:26 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •