Hiding column causes VBA code to behave not as expected

Hi,

Hoping for some help. I have some VBA code in excel (which was provided by dflak) as follows:

Please Login or Register  to view this content.

This code works exactly as I expect. However if I hide column 28 then the code does not behave as I expect. After stepping through I can see that after the hiding column 28 the value for

Please Login or Register  to view this content.

in the line

Please Login or Register  to view this content.

evaluates to having no value even though the cell does contain "TRUE".

Does anyone know if hiding a column that is referenced in VBA can affect tghe way the code runs?

Thanks
Kam Patel

Hi kampatel

The problem is you have used

Please Login or Register  to view this content.

This problem is corrected if you use

Please Login or Register  to view this content.

I believe this is so because .Text gets a formatted / read-only version of the cell value. If the cell is not visible maybe that
visual formatting is not there and thus there may not be enough information to reproduce the value in that cell.

Feel free to correct me on that, anyone, but that's my understanding.

Anyway, the above will fix your problem.

Guys,

Thanks for your help to both. A combination of what you have both said has worked.

Thanks Again
Kam