Thanks Mike the first bit of code worked great. My next problem is the "New" sheet contains a formula in the range d9:d44. The code thinks there is data in these fields and thus won't hide the lines. The formula is a simple one (=Setup!B20) but enough to cause it grief. I need to keep the formula. The output in range d9:d44 is not numbers but words. Can we tweak the code so that it looks for a value in the cells.
Thanks
Rob