Invisible cells in VBA
 

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,

Invisible cells in VBA
 

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

--

Vasant



"Ian" wrote in message
...
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,

Invisible cells in VBA
 

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?




"Ian" wrote:

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,