runtime error '1004' object '_Global' failed

J

Jim in Spokane

When I open the Excel file via Excel my macro works fine.

When I open the file via Windows Explorer the macro errors with a
runtime error '1004' object '_Global' failed on the following line.

UserForm1.Label3 = Worksheets("tables").Range("name_select").Value

Any reason for this?

Thanks
Jim in Spokane
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 1004 Method 'Range' of object '_Global' failed 4
MsgBox including range value 6
"Run-time error '1004' 5
VSTO C# add in Outlook.Appointment error 0
Receiving error 1004 - Method 'Rang' of object '_Global' failed 2
Sort by a Variable Range 2
Application.top=0 fails 3
Excel 2002 and IE7 2

Top