I'd like to hide rows based on data in the row as in
=IF(c5<>1,c12/2,HideRow)
Seems like it shouldn't be too tricky, but just creating a relative macro called "HideRow" doesn't work. Is it a declration thing? Redefining it as publicfunction seems to return "0".
=IF(c5<>1,c12/2,HideRow)
Seems like it shouldn't be too tricky, but just creating a relative macro called "HideRow" doesn't work. Is it a declration thing? Redefining it as publicfunction seems to return "0".