VBA code: A Sub() module to CALL another Sub ()

Hello experts!

I need some expert advice here please....

I have a SaveAsPDF module created that when run, it needs to convert the worksheet into excel. But before doing that, I need another module to run first, that is to check whether certain required fields are filled or not before it converts to .pdf. Pasted are my codes for both modules. I tried calling the Checkcells module but I keep on receiving "Compile error: Argument not optional" message. Or is there a way to incorporate my codes in one module that does both functions?

Please have time to assist. Thanks a lot in advance!

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Thanks again in advance!

What happens if you put your PDF code at the end of the emptycell code to make it one macro?

Originally Posted by jolivanes

What happens if you put your PDF code at the end of the emptycell code to make it one macro?

Hi jolivanes

Tried your suggestion but it still shows same error: "Compile error: Argument not optional"

Originally Posted by hydz1213

Hi jolivanes

Tried your suggestion but it still shows same error: "Compile error: Argument not optional"

CORRECTION TO ME! I tried it again....paste my PDF code under the EMPTYCELL code and it did run which is really good.
However, when I emptied some of the specified cells (C4,E7) it still converts the worksheet into .pdf

I was hoping to have a code that the macro will check first if there are empty cells among specified cells. If yes, it will just highlight empty cells and remind user to fill-in the form first and PDF will not run. But if all specified cells are filled-out, then macro will convert worksheet into .pdf....

[QUOTE=OllieB;3115871]I think you should change the call to CheckCells from the SaveAsPDF routine

AWESOME!!! It worked Thank you so much for your help! I wonder how can I tag this as SOLVED???

But super thanks to your help OllieB

Originally Posted by jolivanes

What happens if you put your PDF code at the end of the emptycell code to make it one macro?

Thanks also to you jolivanes