run-time error '1004' application-defined or object-defined error - Excel 2007

Hi,

I am trying to save my current sheet1 to PDF and attach to Outlook. The error occurs on

ActiveSheet.ExportAsFixedFormat _
Type:=xlTypePDF, _
FileName1:=FName

I believe it has to do with my Range, because i tested the code with a new file with a single cell filled out and it worked. How can i fix it?

Thanks!

Is this solved?

If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.