Thanks for the help. I have resolved the above isued. by giving following "Scrap items - "& VLOOKUP(B11,INDIRECT(SELECT&"!B:C"),2,0) I used...
[img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/05/Untitled.jpg[/img]
Thanks for the reply. I am able to copy the same. I request another help to complete the process as...
[img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/04/Setup.jpg[/img] The picture above shows how the sheet is setup. The picture below shows the result of the...
Thanks Hyside2, Will try out and get back to you. Regards Ozuberk
This Script has Syntax error - I tried to debug but was not successful
Oh sorry forgot the before and after pictures, Here they are. [img alt_text='' description='']http://vbaf1.com/q/wp-content/uploads/2018/04/1-1.jpg[/img]
For this to work please add custom format to format cells. Add 13 zeros as the custom format. See pictures....
I have got an excel sheet that is used to make invoices. Now, I want to export this as PDF and send it on outlook. I managed to create a code that works. The only part which I am not sure about is that there are some parts of the excel sheet that I don’t want to be saved into the PDF. I was wondering if anyone knows a way to do that? I guess it would have to do with changing the part of the code which I am attaching, but I’m not sure what.
Also, I tried just entering Range() after ActiveSheet and then manually input what I DO want. This worked but when saved as PDF, each range is in its own page
Create the PDF
ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:=PDFFile,
Quality:=xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas _
Please share using the share button above.
If you found the answer is best answer for your question, Please mark as 'best answer' by clicking on the right tick mark icon at the left side of the answer.
Found the answer useful and wants to credit the user, then vote the answer (vote up).