View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Man Utd Man Utd is offline
external usenet poster
 
Posts: 23
Default Hide cell range in worksheet

Can I hide the data in a cell range ?
I have some data in a cell range for lookup, say, K10:N30 as MyDataList, I
don't want to show to a user, can I hide these data ?
I think I can put these data on another worksheet and hide that worksheet,
but I don't know how to reference this lookup table in the formnula.