set row height based on contents of cell

  • Thread starter Thread starter keyser_Soze
  • Start date Start date
K

keyser_Soze

I would like to set the height of rows 30,31,32 to 0 based on the
contents of A30, A31, A32 respectively. How do I can I do this in a
macro?

Thanks!
 
somewhat similarly, I would like to set the column width of columns n
through u to 0 if cells in those columns 2,32 are all blank.

Example Column m has text in M1 but m2:m32 is all blank, I would like
it's width to be 0. How can I do this?
 
Back
Top