MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Printing on Excel through macros


Posted by jamie on August 29, 2000 1:35 PM

Our entire database for estimating is on Lotus. We are converting that database to Excel. There is a situation though. We had created a macro that only printed the pages that had new data (for instance, a sheet that had a total value at the bottom would have a number on the far right. The macro would read that that was an active page and printed it. If it didn't have a number, it would not.). Is there a way to create this kind of a macro in excel? Thanks


Posted by Celia on August 29, 0100 5:16 PM


Assuming that when there is a number it is always in the same cell (say, H20), something like this could probably be used :-

Dim ws As Worksheet
For Each ws In Worksheets
If ws.Range("H20") <> "" Then
ws.PrintOut
End If
Next ws

Celia