compile error

Maui

Board Regular
Joined
Jan 13, 2006
Messages
159
I am sending sheet with macro's in.

When some peoplpe recieve the email and run the macro they are getting compile error. Why is it working on some and not others, any ideas.
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.
I dont think its a mcro code related thing. The macro works on some peoples. Here is code if you think it will help

Sub S1_()

ScreenUpdating = False
Sheets(Array("Format", "Area in region", "Area Ranked ")).Select
Sheets("Format").Activate
ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True
Sheets("Area ").Select
ActiveWindow.SelectedSheets.PrintOut From:=11, To:=13, Copies:=1, Collate _
:=True
Sheets("Print").Select

ScreenUpdating = True

End Sub



Basicaslly I send the macro to about 20 people. I have had complaints that some get this compile error. When I send it to a colleague who sits next to me it works, but others it doesnt work.
 
Upvote 0
are they getting any indication why it isn't compiling eg does the VBE open up in debug mode? if so, where is it erroring out on? What is the exact message they are seeing?
 
Upvote 0

Forum statistics

Threads
1,218,576
Messages
6,143,314
Members
450,477
Latest member
teresab543

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
Back
Top