Thread: If Then
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jon M.[_2_] Jon M.[_2_] is offline
external usenet poster
  
Posts: 5
Default 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
Reply With QuoteReply With Quote