View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default Error: Unable to get the OLEObjects property of the worksheet class

Grant,
According to the Object Browser, the OLEObjects collection does not have a
property called "Object'.
What are you trying to achieve ?

NickHK

"Grant" wrote in message
...
Hi there,

I keep getting the following error with the following
code. How might I go around fixing it?

Error: 1004, Unable to get the OLEObjects property of the
Worksheet class.

str = ActiveSheet.OLEObjects("cboLine").Object.Value

Thanks in advance for the replies,

Grant.