How to:

[filo666]

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

[Leith Ross]

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