Thread: Syntax for a macro to unprotect a union of cells
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Roy Peck Roy Peck is offline
external usenet poster
  
Posts: 4
Default 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 QuoteReply With Quote