Min/Max filter to ignore blank range

Hello, I am very new to VBA and completely over my head. I have a sheet created by a VA to filter data based on multiple criteria. There are certain fields that have a min/max filter (C24:D27 & C30:D31). Right now, the macro only runs if there is data in these cells, so the solution is to have it go from 0 to 9999,999,999. It runs if either the min or max for each criteria is blank, but not if both cells are.

Ideally I would like to be able to leave those cells empty and not have to insert the filler text. I have been able to make this work using a simple formula, but I have no idea how to transfer that to a macro. If the cell is blank, it should be treated as 0 in the min column (C) and 999,999,999 in the max (D) column. Is this something that can be done with VBA? The module controlling the MinMax function is below.

Thank you!

Please Login or Register  to view this content.

Possibly...

Please Login or Register  to view this content.

Thank you. Would this replace the entire code or fit into the existing code somewhere?

Hard to say without seeing the file or a sample of it, but I would assume it does not replace your existing code. Whether it runs separately or within your existing code would be your decision. The above code simply fills in the blank cells with either 0 or 999999, depending on the column.