Ok, so here is what im trying to do, if any gurus out there can help, I would
greatly appreciate it.

I need a macro that will go to each sheet in a workbook and send that same
page as an email to the email address in B1 on that sheet. If the value is 0
on the sheet in the B1 field then it needs to skip this sheet and move on to
the next. Any help on this would be greatly appreciated.. im unsure where to
start with it. Thankyou!