missing syntax when saving as pdf

[chubbychub]

hi, I have a macro that is missing a sysntax IF, then statement or an error

Please Login or Register  to view this content.

I get compile error, please help.

[TMS]

Maybe try:

Please Login or Register  to view this content.

[chubbychub]

I get compile error, not optional format message.

[chubbychub]

Can any VBA master help me please?

[shg]

The dot at the beginning of the statement says to use a reference established by a prior With statement, which your code doesn't contain. That's why TMS suggested ThisWorkbook.Export -- but only you know what the code is supposed to do, and you haven't shared that.

Did you write this code, and if not, where did it come from?

[chubbychub]

I just copied the code from a tutorial and add it in

[shg]

The code was missing the statement?

Again, what are you trying to do?

[chubbychub]

just save the file into pdf format, I read tutorials and change the 2 lines in red and it works, but not sure if its right, I just saw all the tutorials having it so I change it and it works, please tell me if its right.

Please Login or Register  to view this content.

[TMS]

If it works, and it does what you want, it's probably right. The issue is that you have code that you do not understand.

You would be better off recording a macro while you save your fie as a .pdf and see what you get.

[chubbychub]

what does this 2 lines means :
Dim strFilename As String <----------------------THIS LINE WAS ADDED
Dim rngRange As Range <---------------------- THIS LINE WAS ADDED

[TMS]

See: http://www.thespreadsheetguru.com/bl...ing-vba-macros and https://msdn.microsoft.com/en-us/library/7ee5a7s1.aspx or https://msdn.microsoft.com/en-us/lib.../gg264241.aspx

Or just Google Excel VBA Dim

[TMS]

Thanks for the rep.