How to:
 

1) Print 3 copies of a specific region in the same page (the fatest and
easiest)
2) I made a function (the tipical function of convert numbers to cardinals
(two thousand etc etc etc)), my problem is, when I pres a number (any number)
the entire macro is evaluated, and this happends with all the numbers I type,
as you can imagine, this takes long, so, There is a way to evaluate the
function just if certaines cells are changed (or certaines sheets are
selected)????

TIA

How to:
 

Hello filo666,
In response to question number 1, here is the code. Change the
worksheet name and range to what you are using.

Code Example:

With Worksheets("Sheet1")
..PageSetup.PrintArea = "A30:F60"
..PrintOut Copies:=3
End With

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=488247