Hello everyone,
I'm not sure how tricky this one might be, but here's what I'm trying to do:
On one worksheet, I have ten defined names. Each name is basically a collection of rows (the whole row). So, for example, rows 9 to 18 have the name GoTo01, and rows 19 to 32 have the name GoTo02 (the number of rows varies in each name). What I want is a macro that will hide each name (so hide the rows) providing the total value is zero. So basically, I want it to select GoTo01 and if the sum of that is zero I want it to hide it and then move on to do the same thing for GoTo02... etc etc.
Does that make sense? I know I haven't explained myself very well.
Thanks again everyone!
Bookmarks