Hi Susan

Maybe easier ?

Clear the print area and it will print all the data on the worksheet


--

Regards Ron de Bruin
http://www.rondebruin.nl/tips.htm


"Susan" wrote in message ...
Help,

we are constantly adding new data and trying to write a macro (which I am
new to) that will set the print area automatically to the last row with data
in it. Can someone please help me.... I have no idea what i am doing and
the people i am writing this for have less knowledge.

Any help would be appreciated!