Macro triggering other Subs not working: Weird

[SakiSam]

I have a Module that has worked for almost a year but is now not working. I've had to rebuild the worksheet because of a un-delete-able style issue that was causing confusion on the part of the end users. So I copied this module into the new workbook.

Here's a sample:

Sub VehInv()    cntYear = (ThisWorkbook.Sheets(xPage11).Cells(Rows.Count - 1, PivTbl).End(xlUp).Row - 4)
    Sheets(xPage01).Select
'Clear existing Table
    ClearOldData
'The first TagType, alphabetically
    TagTypeB
'Other Tag Types
    TagTypeO
'Format Present
    FormatChart

If Sheets(xPage01).UsedRange.SpecialCells(xlCellTypeLastCell).Offset(-1) = "" Then Sheets(xPage01).Range(Sheets(xPage01).UsedRange.SpecialCells(xlCellTypeLastCell).End(xlUp).Offset(1), Sheets(xPage01).UsedRange.SpecialCells(xlCellTypeLastCell)).EntireRow.Delete shift:=xlUp
End Sub
______________________________________________________________________________________________________

Sub ClearOldData()
    rownum = Sheets(xPage01).Cells(fstRow, fstcol).End(xlDown).Row
    Sheets(xPage01).Range(Sheets(xPage01).Cells(fstRow, fstcol).Address & ":" & Sheets(xPage01).Cells(rownum, lstcol).Address).EntireRow.Delete shift:=xlUp
End Sub

When I trigger "VehInv" the code works as it should and runs the sub "ClearOldData". However after ClearOldData completes, the Macro stops and never returns to VehInv to run the next step.

I've tried checking VBA's Options and Reference(Library's.) Can anyone tell me how to fix this?

 

[RoryA]

Do you have any event code in the xPage01 sheet? Or any conditional formatting that uses UDFs?

 

[SakiSam]

I do not have any VBA in the xPage01 sheet. but I do have a conditional formatting that uses a UDF. If it matters, the condition is on a cell that is not included in the "ClearData" and uses a cell that is also not included.

=ISERROR(COUNTav($H$2))

 

[RoryA]

If you save a copy of the workbook and clear that conditional formatting, does the code then work?

 

[SakiSam]

That did it. Any idea why that happened? Is it because the UDF includes "Application.Volatile"?

 

[RoryA]

No (Conditional Formatting is volatile anyway). There are certain properties of ranges that aren't always valid and if your UDF tries to access them from within CF at the wrong time, it simply terminates all code without warning. Most of the time you can work around it with error handling, or an alternative approach.