Invisible cells in VBA

[Ian]

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.

--

Vasant



"Ian" <Ian@discussions.microsoft.com> wrote in message
news:93F782EF-D30C-4E60-8887-BB0017566EB0@microsoft.com...
> 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,

[Patrick Molloy]

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,