As always, post YOUR code for comments

if range("a21")<1 then exit sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stan Halls" wrote in message
...
I have a print macro set up to print an area in a spreadsheet, is it poss
to
have it look at a cell and chech to see if that cell on the sheet is
greater
than £0
if its value is greater than £0 then print if not then dont print ..
Thanks in advance for any ideas