Creating A New Sheet Using VBA

[fa2020]

Hi friends,
I want to create a new sheet using VBA. I allocated my code (I learnt it from web) to a button but it fails to run. I tried to create a class module and then the main module, but the error says the function has not been defined.
The plan is that the code must check the new page name and if it does not exist, creates it, else nothing happens.
Please guide me.

[maniacb]

This line usually works:

Sheets.Add 'Create new sheet

[Fluff13]

The function should be in a normal module, not a class module. However you don't need it.
You could just use

Please Login or Register  to view this content.

[maniacb]

This works, not sure what the if then does:

Please Login or Register  to view this content.

[Fluff13]

@maniacb
That just adds a new sheet & names it. It doesn't check if the sheet exists first.