- Codice: Seleziona tutto
Sub PROVA()
'
' PROVA Macro
'
'
If [A1] = "FOGLIO ORDINI" Then
Beep
MsgBox "Inserire nome cliente"
Exit Sub
End If
Application.ScreenUpdating = False
Range("F3:F50").Select
Selection.Copy
Windows("totali.xlsm").Activate
Range("F3:F50").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlAdd, SkipBlanks:= _
False, Transpose:=False
Windows("1foglio ordini vuoto.xlsm").Activate
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = ""
Range("M3:O50").Select
Selection.Copy
Windows("totali.xlsm").Activate
Range("M3:O50").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlAdd, SkipBlanks:= _
False, Transpose:=False
Range("A2").Select
Windows("1foglio ordini vuoto.xlsm").Activate
ActiveSheet.Paste
Application.CutCopyMode = False
Dim Nomefile
Nomefile = Range("A1").Value
ActiveWorkbook.SaveAs Filename:=Nomefile
Range("A1:P61").Select
ActiveSheet.PageSetup.PrintArea = "$A$1:$P$61"
ActiveWindow.SelectedSheets.PrintOut Copies:=1
If [ Q4] <> "0" Then
ActiveSheet.PageSetup.PrintArea = "$Q$2:$V$27"
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End If
If [ W4] <> "0" Then
ActiveSheet.PageSetup.PrintArea = "$W$2:$AB$27"
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End If
If [ Q30] <> "0" Then
ActiveSheet.PageSetup.PrintArea = "$Q$28:$V$54"
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End If
If [ W30] <> "0" Then
ActiveSheet.PageSetup.PrintArea = "$W$28:$AB$54"
ActiveWindow.SelectedSheets.PrintOut Copies:=1
End If
Application.ScreenUpdating = True
ActiveWorkbook.Close sAVEcHANGES:=False
End Sub
Qualcuno nota errori ?