IF cell=error execute sub 1 if value execute sub 2... possible?

Hi amazing humans, I'm wondering if it's possible to program a macro to execute a certain section of code depending on the value of one cell.

Essentially my code currently grabs 4 cells, and uses those values to filter on another tab.

One of the codes has the possability to be blank or an error, however this has the potential to deliver a blank table after the filter runs.

I'm wondering if it's possible to start the function with something to the effect of.

"if A5 is error then it runs sub 2", the current code is as follows, and the Acct_Value is the potential error/blank

Please Login or Register  to view this content.

Thanks for taking a look

Bump? Sorry if that's bad eddiquitte, still working on this problem and having no luck.