Posted to microsoft.public.excel.programming

Spencer Hutton[_4_] Spencer Hutton[_4_] is offline

external usenet poster

Posts: 10

clear captions from all labels

i have a sheet with over 100 labels on it. i need a statement that will set
all of their captions to blank. this is what i have, but it is not working.
can someone help

For Each Label in Sheets("PickSheet").Labels
Label.Caption = ""
Next

how can i rephrase this to make it work. TIA.

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
X axis captions	Stefi	Charts and Charting in Excel	6	September 11th 08 01:16 PM
Cell values as captions	TUNGANA KURMA RAJU	Excel Discussion (Misc queries)	1	July 24th 06 12:29 PM
How do I put captions on Excel charts?	pgrizzell	Charts and Charting in Excel	1	June 8th 06 10:14 PM
reset menu captions	T	Excel Programming	2	November 12th 04 11:28 AM
Clear Textboxes, Labels, and Checkboxes	milo[_2_]	Excel Programming	1	October 16th 03 09:21 PM

All times are GMT +1. The time now is 11:59 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us