View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris Gorham[_3_] Chris Gorham[_3_] is offline
external usenet poster
 
Posts: 31
Default cell number in collection

Hi,

I'm cycling through an object call cellcollection

Set cellCollection = Selection.SpecialCells
(xlCellTypeFormulas)

For Each cell In cellCollection

totcell = cellCollection.count
cellnow = ???
percent_done = cellnow / totcell

next cell

what's the syntax for cellnow..??

Thks

Chris