Hi,
Trying to write a code that will trigger a command button to print out sheet "ClientInput", but only print cells with data. I have tried plenty of different variations of code, but they always seem to either print one page only, or print 2600 pages (I have formulas that will only produce results if the userform inputs to those cells). Is there a way to print all the rows that have data in them, and not include cells with formulas?
Trying to write a code that will trigger a command button to print out sheet "ClientInput", but only print cells with data. I have tried plenty of different variations of code, but they always seem to either print one page only, or print 2600 pages (I have formulas that will only produce results if the userform inputs to those cells). Is there a way to print all the rows that have data in them, and not include cells with formulas?
