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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching for Boolean Cells 1
Extending a selection 2
SpecialCells - no cells selected 1
VBA set thick borders around non empty cells in range 0
for each in a range 1
Cycling through collection 8
Problems in copying a Collection to another and removing elementsfrom two Collections 6
changeNumberFormat macro 2

Back
Top