May be, by hiding the rows that contains formula, before printing
A cell contaning formula can be detected by *HasFormula property*
Please check this code if it helps.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim MyRng As Range, r As Long, c As Integer
Set MyRng = ActiveSheet.U
Is there a way to print the rows with data in them and not print the
rows with just the formula. My spreadsheet has several rows with
formulas in them and I only want to print the rows which I have added
data. I know you can select print area and all that. But mainly it's
for the inexperianced user
