Posted to microsoft.public.excel.programming

peter.thompson[_64_] peter.thompson[_64_] is offline

external usenet poster

Posts: 1

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Data cleanup	sjs	Excel Worksheet Functions	1	September 16th 09 03:37 PM
Code cleanup	peter.thompson[_53_]	Excel Programming	2	January 18th 06 06:16 AM
Code cleanup help please	peter.thompson[_8_]	Excel Programming	5	December 22nd 05 07:08 AM
Leo Heuser format cleanup code, and a question	GatesAntichrist	Excel Programming	3	July 2nd 04 04:18 AM
Source Data Code Cleanup Help	John Michl[_2_]	Excel Programming	2	August 18th 03 09:01 PM

All times are GMT +1. The time now is 06:09 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us