- Codice: Seleziona tutto
Sub SALVA_IN_ARCHIVIO()
ActiveSheet.Unprotect
Application.ScreenUpdating = False
Sheets("ARCHIVIO").Visible = True
Sheets("ARCHIVIO").Select
ActiveSheet.Unprotect
Rows("4:4").Select
Selection.Insert Shift:=xlDown
Sheets("HOME").Select
Range("E5").Select
Selection.Copy
Sheets("ARCHIVIO").Select
Range("B4").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("HOME").Select
Range("H5").Select
Selection.Copy
Sheets("ARCHIVIO").Select
Range("C4").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("HOME").Select
Range("C6").Select
Selection.Copy
Sheets("ARCHIVIO").Select
Range("D4").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("HOME").Select
Range("F9").Select
Selection.Copy
Sheets("ARCHIVIO").Select
Range("F4").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("HOME").Select
Range("F10").Select
Selection.Copy
Sheets("ARCHIVIO").Select
Range("G4").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("HOME").Select
Range("I35").Select
Selection.Copy
Sheets("ARCHIVIO").Select
Range("E4").Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False
Sheets("ARCHIVIO").Visible = False
Secondo voi dove sto sbagliando? funziona solo in parte. Il problema è che non esegue la copia delle celle F9 e F10 del foglio HOME nelle relative celle del foglio ARCHIVIO.
grazie