VBA Compile Error

Thank you everyone who replied! The code is good, but there was non-breaking spaces or invisible characters that caused the compile error for me. After removing those, it ran successfully! So excited for my first VB! Thanks again!

First time posting and first time using VB in Excel. I am trying to write a VB program to format all the tabs in my Excel file to make sure every tab has the same font and size. Below is my code. When I run F5 to run, it gave me "Compile error: Syntax error". Please help. Thanks.

Below is what I did.
Press Alt + F11 to open the VBA Editor in Excel.
Go to Insert > Module.
I copied the below code into the Module window. Then I pressed F5 to run. I received "Compile error: Syntax error".

Please Login or Register  to view this content.

Hello @mamawanttolearn
No any error on my side, code work fine!

Please Login or Register  to view this content.

Welcome to the Forum mamawanttolearn !

Administrative Note:

We recommend that you include code tags around your code. I have added them for you since it's your first post.

Posting code between [code]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/code] tags makes your code much easier to read and copy for testing, and it also maintains VBA formatting.

Please see Forum Guideline #2 about code tags and adjust accordingly. Click on Edit to open your post, then highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here.

I tried it too, no syntax error and it ran to completion.

Double check that what you pasted into the editor is exactly what you showed us here. Maybe when you did the "copy" you missing something.