Send Email With Multiple Tables In Body Dynamic Ranges with if Statements

Dear Everyone,

I am new to VBA and I would like to kindly ask you how to do the following coding: I want to say if the value on a specific cell is numeric error thus #NUM! then, I want to attach two specific tables as body on an outlook mail otherwise send a message "no changes". I do not need the full code for attachments etc. cause I have already written it. I only need a code for the if cell a1 is numeric error then attach the following dynamic range.

Thanks in Advance!!!