Compile error: Else without If

defreitj

New Member
Joined
Jan 20, 2005
Messages
2
I can install excel!
The user's computer has been changed...several times.
The only user to have this recurring problem.

The user opens three excel 'sheets' and switches betweenn them using the task bar.
This "Compile error: Else without If" appears and does not stop occuring.

Installed sp4 for Win 2000 pro.
Re & re Office suite...no change.
Went to server and opened same files, no error.
Went back to user's machine...same error.

Please, what is creating the error message..the worksheet OR the machine OR the application OR ...as you can see I don't know what questions to ask here for help.
I have gone through the 50 pages of messages but none show a similar error message.
But I know that someone out there can interpret this dilemma.
Thank you in advance for any input.
I do not use or know or understand spreadsheets. I support a network of devices and monitoring and upgrades so this is like 'brain surgery' to me.
Sincerely,
jd
 

Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
There's probably some code attached to the workbook or worksheet.

Press Alt-F11 to open the VBE.
Press Control-R to open the Project Explorer.
Click "Microsoft Excel Objects" for the file you're working on.
Open the Code pane with F7.
Double-click the sheet you're working on, and also "ThisWorkbook" for that file.
If you see any code in there, post it here, so we can see what might be happening.
Press Alt-Q to close the VBE and return to Excel.

Other than someone putting code in that file as a joke, or maybe they forgot to take it out, I don't know what else to suggest. Hope that helps!
 

defreitj

New Member
Joined
Jan 20, 2005
Messages
2
MR. Tazguy,
Thanks a million!
I will use your solution.
If it works I will lrt you know, if not I will get a job as a janitor..
Thanks a lot, dude! Really appreciate the quick response.

jd
 

Forum statistics

Threads
1,148,219
Messages
5,745,452
Members
423,952
Latest member
EduardoM

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top