General discussion

Locked

Excel Macro for printing

By dav.owen ·
I want to write a macro in Excel which is assigned to a command button that when pressed will print out multiple sheets if data is in a given cell, but will not print the sheet if the given cell is empty. Anyone have an idea?

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

by Juergen Hartl In reply to Excel Macro for printing

Application.ScreenUpdating = False
Dim w As Worksheet
dim r as range
For Each w In ActiveWorkbook.Worksheets
Set r = w.Cells(row,col)
if r.Value<>"" then
w.PrintOut
end if
next

Collapse -

by dav.owen In reply to

This did not work for me but if anyone has the same problem I have designed a macro that has worked for several clients

Collapse -

by dav.owen In reply to Excel Macro for printing

This question was closed by the author

Back to Web Development Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums