Public function to create new sheet, with optional argument

Hello,
I am working on a small piece of a larger project and am having issues getting it to work.

It is a public function with one required argument and one optional argument. It creates a new sheet named after the first REQUIRED argument, and places it at the end of all sheets if the second OPTIONAL argument is omitted, or if the second OPTIONAL argument is specified, places it after the sheet named by the second OPTIONAL argument.

It currently works when specifying both arguments, but I cannot figure out how to make it work when the optional argument is omitted.

Please Login or Register  to view this content.

Thank you for your reply, and it functioned as it was, however when used without an argument it placed the new sheet where you were currently selected within the workbook instead of at the end.

I was able to take your code and modify it to work correctly, both with the optional argument and without. I however, doubt this is the best way to achieve this, I ended up having to be rather repetitive to get it to work.

Any suggestions are welcome.

Please Login or Register  to view this content.

Again, thank you protonLeah for your help thus far.

Thank you protonLeah, the function still performs as intended after that small optimization.

I will now mark this as solved.

Thank you for your help and time,
Trent Spencer - KM4YTU