cell number in collection

  • Thread starter Thread starter Chris Gorham
  • Start date Start date
C

Chris Gorham

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
 
cellnow = 0
For Each cell In cellCollection
cellnow = cellnow + 1
totcell = cellCollection.count
percent_done = cellnow / totcell
 
Back
Top