View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
peter.thompson[_64_] peter.thompson[_64_] is offline
external usenet poster
 
Posts: 1
Default Code cleanup help


Thanks Norman,

Wouldn't work with Sheets("Sheet7").OLEobjects syntax

but does work with plain Sheet7.OLEObjects

Why is this the case?

Again, thanks for all the help on my first VBA project!

Cheers

Peter


--
peter.thompson
------------------------------------------------------------------------
peter.thompson's Profile: http://www.excelforum.com/member.php...o&userid=29686
View this thread: http://www.excelforum.com/showthread...hreadid=503729