Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional auto printing in excell?
How do I write macro for conditional auto printing in excell? I have tried
things like: if L20 then print. This would be that a number greater than 0 would get the system to print the page. This is to be encorporated into an existing macro that currently prints every page even if no data is on line 2 of the spreadsheet. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional auto printing in excell?
You should always post your coding efforts for comments and suggestions.
if range("l2")0 then range("a2:l2").printout -- Don Guillett Microsoft MVP Excel SalesAid Software "Steve" wrote in message ... How do I write macro for conditional auto printing in excell? I have tried things like: if L20 then print. This would be that a number greater than 0 would get the system to print the page. This is to be encorporated into an existing macro that currently prints every page even if no data is on line 2 of the spreadsheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do you add to auto fill in excell? | Excel Discussion (Misc queries) | |||
How can I set up an auto return to the next column in excell? | Excel Worksheet Functions | |||
Excell 2003 printing | Excel Discussion (Misc queries) | |||
PRINTING LABELS FROM EXCELL WORKSHEET | New Users to Excel | |||
printing and font changes in Excell | Excel Discussion (Misc queries) |