Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Method 'Worksheets' of object '_Global' failed error

Status
Not open for further replies.

fdgsogc

Vendor
Joined
Feb 26, 2004
Messages
160
Location
CA
I am getting the following error Method 'Worksheets' of object '_Global' failed when I step through my macro in Excel. On my local desktop I have no issues. But when I post this Excel file on my website, I get the error.

So the macro is running erratically. Please go to click Yes to allow macros and then go to the Visual Basic Editor and step through the macro. At the set sortselection line I get the error.
 
You seem to be in the wrong forum, try for Microsoft Office.
 
Thanks. I have re-posted to Microsoft:Office forum.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top