Does anyone know a vb code to print a specific page # if a
certain cell is not null or has a specific value?

Felice,
assume cell to check is A1

if range("a1")="" or range("A1")=Your_Value then
sheets(1).Printout from:=your_page, to:=your_page
end if

Throw this in the worksheet_change event, and it should work for you.

Steve
"Felice" wrote in message
...
Does anyone know a vb code to print a specific page # if a
certain cell is not null or has a specific value?