The only way to do it would be to loop through the range of cells and create
the array by accessing the property of each cell (to the best of my
knowledge). This would defeat the purpose of making the code faster and more
efficient though, so I would have to say it will not work for you.
--
HTH...

Jim Thomlinson


" wrote:

I often read and write chunks of Excel data by reading them into a
variant array, process the data, and then write the changes back. As
most know this is a very effecient method.

I would like to do the same think with a range of cell properties. For
example I would like to be able to individually check which cells on a
sheet contain a formula. I am currently reading the cells into a range
object and looping through each cell in the range. The ones with a
formula I am applying a special format.

Is it possible to read the .HasFormula property into a variant array
and loop through the array instead of through the range. I think it
might be faster but cannot get it to work.

Any help or direction is appreciated.
Thanks
Darryl Smith