Posted to microsoft.public.excel.programming

Roy Peck

external usenet poster

Posts: 4

Syntax for a macro to unprotect a union of cells

Have a union of a hundred cells similar to the line of code below.
set cell???? = range("??")
Set allcell = Application.Union(cell1720, cell1721, cell1722)
allcells.Value = ""
allcells.Font.ColorIndex = 0

What is the syntax to unprotect all cells in "allcell"
--
roypeck

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
Unprotect in a macro	Partly Void[_2_]	Excel Discussion (Misc queries)	3	October 5th 08 10:45 AM
unProtect some cells on the spreadsheet	Souris	Excel Programming	0	August 20th 05 11:56 PM
Union/Range/Cells	KentÃ„[_3_]	Excel Programming	2	March 11th 05 11:14 AM
printing a union of non-contiguous cells- help!	noel mcwilliam	Excel Programming	0	December 3rd 04 04:15 PM
printing a union of non-contiguous cells- help!	noel mcwilliam	Excel Programming	0	December 3rd 04 04:13 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us