IF Then in VBA

[wesleyu]

Hi guys,

I've made a excel sheet with several macro's in VBA.

I'd like to add a test before the document is saved automatically to PDF.

Please Login or Register  to view this content.

If it appears that the value of the second column of the test (Vlookup) is empty then I'd like Excel to do nothing, otherwisde I'd like it to execute the function.
The way I wrote the code doesn't work.

Hope someone can help me with this.

Thanks in advance!

Kind regards,

Wesley

[hemesh]

then try using
End Sub in place of 'do nothing

[stnkynts]

then try using
End Sub in place of 'do nothing

That is incorrect. @wesleyu, can you be more specific on what you are trying to test for in this line

Please Login or Register  to view this content.

[wesleyu]

@Hemesh and stnkynts, thanks for your reactions!

Vlookup is going to find a cell according cell D14. I'd like to test if the cell that Vlookup finds is empty ("").

[hemesh]

you could use
Msgbox "Vlookup has found an Empty cell"

[stnkynts]

you could use
Msgbox "Vlookup has found an Empty cell"

Again also incorrect. @wesleyu I need you to be more specific on what you are trying to do (your previous response was still very vague). Odds are that there is a better way to do it than a vlookup in code and unfortunately I cannot trust that your formula is correct since you said "The way I wrote the code doesn't work". Be very specific on your next post or this will be my last response.