View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Vasant Nanavati Vasant Nanavati is offline
external usenet poster
 
Posts: 1,080
Default 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,