Example - I have three named ranges:
Yellow: A1:D8
Green: All:D18
Blue: A21:D28
There is data in first cell of each range:
A1 = 1234
A2 = 0
A21 = 1234
These values may vary but what I want to do is to have a macro that will select ONLY the ranges whose values in the first cell is greater than 0.
Any help would be greatly appreciated.
Yellow: A1:D8
Green: All:D18
Blue: A21:D28
There is data in first cell of each range:
A1 = 1234
A2 = 0
A21 = 1234
These values may vary but what I want to do is to have a macro that will select ONLY the ranges whose values in the first cell is greater than 0.
Any help would be greatly appreciated.