Complie error: End If without If

**Seler Naciowy** · 11-28-2008, 01:26 PM

Hi,

I'm writing a bit of a code that will re-format all sheets in spreadsheet except the three named. I keep on getting compile errors whatever I do. It's driven me mad.

Could you please have a look at this and tell me what the heck is wrong?

Please Login or Register  to view this content.

Thanks a million!

**VBA Noob** · 11-28-2008, 01:31 PM

This should get you started

Need to change activesheet to ws

Please Login or Register  to view this content.

VBA Noob

**solnajeff** · 11-28-2008, 01:35 PM

Hi

The error is in the following line

Please Login or Register  to view this content.

There should not be an underscore as the select statement should be on the next line, also should be just ws.select.

Regards

Jeff

**Seler Naciowy** · 12-01-2008, 06:49 AM

Thanks, this was very helpful.
The solution was the combination of the two answers.

Please Login or Register  to view this content.

Thanks a million for your help!

Seler

Complie error: End If without If

LinkBack

Thread Tools

Rate This Thread

Display

Complie error: End If without If

Compile error

Thanks!

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions