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