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 dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

User-defined type not defined

Status
Not open for further replies.

tbiceps

IS-IT--Management
Nov 23, 2005
106
US
The error message listed below references the following line of code:

' Create a reference to the current objects.
Dim Objs As OLEObjects
Set Objs = Sheet3.OLEObjects

Does anyone have any ideas?

---------------------------
Microsoft Visual Basic
---------------------------
Compile error:

User-defined type not defined
---------------------------
OK Help
---------------------------
 
I think you need a reference to the Microsoft Excel x.x Object Library.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top