read hidden cells; vba
 

I loop thru a range of cells on a sheet and generate a checksum.
Hidden cells are apparently not read. Is there an “omnipotent”
setting I can make to just make reads work, or do I have to test the
value of hidden, turn it off, read it, and return it to hidden?

Thank you.

read hidden cells; vba
 

Cate,

Post your code - hiding cells affects some functions and not others.

HTH,
Bernie
MS Excel MVP


"cate" wrote in message
...
I loop thru a range of cells on a sheet and generate a checksum.
Hidden cells are apparently not read. Is there an “omnipotent”
setting I can make to just make reads work, or do I have to test the
value of hidden, turn it off, read it, and return it to hidden?

Thank you.

read hidden cells; vba
 

On Nov 20, 9:55*am, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
Cate,

Post your code - hiding cells affects some functions and not others.

Set mySheet = Application.ThisWorkbook.Worksheets("CoolantGroup" )
Set rgHome = mySheet.Cells(1, 1)

colEnd = INITIAL_SUBMISSION_COLS
rowEnd = INITIAL_SUBMISSION_ROWS
barrel = 1#
For colIndex = 1 To colEnd Step 1
For rowIndex = 1 To rowEnd Step 1
cellText = rgHome.offset(rowIndex, colIndex).Text
checksum = ha****(cellText, checksum)
Next ' row
Next ' col

read hidden cells; vba
 

Cate,

How are you "hiding" the cells? Nothing in your code is apparently wrong - unless you are applying
a custom format of ;;; to hide the cell.

But I would change

cellText = rgHome.offset(rowIndex, colIndex).Text

to

cellText = Format(rgHome.offset(rowIndex, colIndex).Value,"some appropriate format string")

which should remove any formatting considerations.

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


"cate" wrote in message
...
On Nov 20, 9:55 am, "Bernie Deitrick" <deitbe @ consumer dot org
wrote:
Cate,

Post your code - hiding cells affects some functions and not others.

Set mySheet = Application.ThisWorkbook.Worksheets("CoolantGroup" )
Set rgHome = mySheet.Cells(1, 1)

colEnd = INITIAL_SUBMISSION_COLS
rowEnd = INITIAL_SUBMISSION_ROWS
barrel = 1#
For colIndex = 1 To colEnd Step 1
For rowIndex = 1 To rowEnd Step 1
cellText = rgHome.offset(rowIndex, colIndex).Text
checksum = ha****(cellText, checksum)
Next ' row
Next ' col

read hidden cells; vba
 

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.

read hidden cells; vba
 

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.

read hidden cells; vba
 

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.


.