Hi Guys,

I have a spreadsheet which has some VBA code behind it and it all works fine. However I have found that if I hide a column that is referenced in the VBA Code the value of the cell is empty as opposed to the value that is actually in it.

Please Login or Register  to view this content.
So above code works exactly as I want however when I hide column 7 the code behaves as follows

The following line does set the cell value to TRUE:

Please Login or Register  to view this content.
as expected, however when the evaluation of this cell takes place in the following line of code:

Please Login or Register  to view this content.
the value for 

Please Login or Register  to view this content.
is empty. Any idea why hiding cells would cause the value to be empty?

Any help appreciated.

Thanks