Forum

That half-worked. 1. The macro tried to email worksheets that had something other than an email in cell E1 2. then half-way through the worksheets di...

OK. You lost me. I have know idea what you are talking about.

Ok. Tried to run it now I am getting a Run time error '1004' at the following line ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFF...

There are some worksheets in the workbook that I use for variables and calculations that I don't want to email that have some text in E1. So I want t...

Instead of saying if the text is > 0, can it say if and email is entered into E1...

I am getting a compile error at the ; Also, and I know this is stupid, where do I insert the subroutine above?