Beware of the differences between cells hidden thru filtering or hidden using
the Hide option. With the latter they are available to manipulate in
interactive mode. And guess what, in macro mode you can also manipulate cells
hidden thru filtering - NOT THE WAY TO GO!

--
Ken
"Using Dbase dialects since 82"
"Started with Visicalc in the same year"


"Bernie Deitrick" wrote:

cate,

I'm still not sure why you are not able to read those cells - what is their formatting? How are they
hidden? And yes, you can always read the Value of a cell - no matter what.

HTH,
Bernie
MS Excel MVP


"cate" wrote in message
...

Also, you should note that your code is looping through cells starting at B2, not A1, which may
or
may not matter.

HTH,
Bernie
MS Excel MVP

DOH!


And yes, there are cells that are purposely hidden on the protected
sheet.


I assume the format construct will allow me to read these 'hidden'
cells, or am I out of luck?

Thanks yet again.


.