If Then
 

How do I need to state the following so that it will
work??

If ('Balance'!J23) 0 Then Sheets("Invoice").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
Collate:=True

Thank-you

If Then
 

Hi
try
sub print_it()
if worksheets("Balance").range("J23").value0 then
worksheets("Invoice").printout Copies:=1, Collate:=True
end if
end sub

--
Regards
Frank Kabel
Frankfurt, Germany


Jon M. wrote:
How do I need to state the following so that it will
work??

If ('Balance'!J23) 0 Then Sheets("Invoice").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
Collate:=True

Thank-you

If Then
 

-----Original Message-----
Hi
try
sub print_it()
if worksheets("Balance").range("J23").value0 then
worksheets("Invoice").printout Copies:=1,
Collate:=True
end if
end sub

--
Regards
Frank Kabel
Frankfurt, Germany


Jon M. wrote:
How do I need to state the following so that it will
work??

If ('Balance'!J23) 0 Then Sheets("Invoice").Select
ActiveWindow.SelectedSheets.PrintOut Copies:=1,
Collate:=True

Thank-you
.
Thanks, it works perfect.