Invisible cells in VBA

[Guest]

I want to make a range of cells on one of my worksheets invisible to the
viewer although the data in the cells will still be availble to the code. I
have selected the range but don't know the property or method for making the
cells invisible. I tried " .Visible = False" on the selection but I got an
error message.

Thanks for any help,

 

[Vasant Nanavati]

You can't make individual cells "invisible." You can hide entire rows or
entire columns.

 

[Guest]

if you don't want to hide the rows then you could simple format the row to
";;;"
They will appear empty but seelcting the cells will still reveal their values.
Why not just put the data onto another sheet?