Set print range for all cell containing data but ignoring formulas

Set print range for all cell containing data but ignoring formulas

I have a simple test formula to get get the range of cells with data in them. Works fine as a test. The problem is that my sheet contains formulas and excel treats them as data.

I can’t find a way of ignoring them they are simple formulas. i.e A1 =Sheet2!B4. it’s a blank cell to look as as that cell in sheet2 is blank and I don’t want sheet1 printing it and wasting paper.

This is the test macro I am using.

Please Login or Register  to view this content.

Thanks in advance for help with my first post.

Solved it my self

Please Login or Register  to view this content.

thanks for my help... its fine thanks. I know, no thanks really...