I'm trying to name a dynamic range using Offset.
When I test the range the "dancing ants" cover the wrong area so I've obviously not grasped the concept of the Offset function.
I also cannot get it to work at all if I add the ">0"
What I'm trying to achieve is to have the named range expand to cells that have a value greater than 0 in row 4 from column C to column BB.
If I can get my head around this, I can alter the formula for more ranges and build a dynamic chart.
I have added a flat file so you can see what I'm trying to work with.
As always your time is appreciated