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

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