VBA to insert new sheet

[cmccabe]

The code below runs fine except when I insert the sheet_name_to_create line towards the bottom. Something seems to be wrong with the syntax, but I can not figure it out. Basically, I am trying to create one button that will classify and after that insert a new worksheet.Thanks.

Please Login or Register  to view this content.

[Kaper]

if in A2 is a valid name for sheet then after adding new sheet

Please Login or Register  to view this content.

shall work fine

[cmccabe]

So is that

Please Login or Register  to view this content.

Thanks.

[Kaper]

No this will be interpreted that way that first

Please Login or Register  to view this content.

is evalueated and then
ActiveSheet.Name will be assigned result of the above (false or true).


I ment:

Please Login or Register  to view this content.

but again, frankly: double check if A2 is proper sheetname.

[cmccabe]

sheets_name_to_create is highlighted and variable not defined. Thanks.

Please Login or Register  to view this content.

[Kaper]

So ... define these names.

Please Login or Register  to view this content.