View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Luc Luc is offline
external usenet poster
 
Posts: 23
Default Setting row height to 0 in the visible celss of a range


Hello there,


-I have a range of cells named "All"
-This range consists of a part of a column (for example A30-A1000)
-Depending on some paramaters not all of the rows of the range "All" are
visible (example : A40 to A55, A120 to A141 ,,, A750 to A766 are visible).
-I want to change the row height of the visible cells in the range "All"
which are empty to 0 row height (in fact hidden).
-Can someone provide me some code to do this


Thanks,

Luc