Dobijam Run time error 9 Subscript out of range šta trebam da promenim?
Code:
'
' Macro1 Macro
'
' Keyboard Shortcut: Ctrl+w
'
Range("C2:AA53").Select
Selection.Copy
Sheets("Sacuvano").Select
Range("A1").Select
Range("A65536").End(xlUp).Offset(1, 0).Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Sheets("Gradevinski dnevnik").Select
ActiveWindow.SmallScroll Down:=-18
Range( _
"E3:L3,E4:L4,F8,F10,F12,H8,H10,H12,M8:P13,Z4,U8,U10,U12,W8,W10,W12,Y8:AA9,Y10:AA10,Y12:AA12,C16:S17,C19:S20,C22:D50,S22:S50,E44:Q50" _
).Select
Range("E44").Activate
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = ""
Range("C22").Select
ActiveCell.FormulaR1C1 = ""
Range("D22").Select
ActiveCell.FormulaR1C1 = ""
Range("F8").Select
ActiveCell.FormulaR1C1 = ""
Range("H8").Select
ActiveCell.FormulaR1C1 = ""
Range("U8").Select
ActiveCell.FormulaR1C1 = ""
Range("Y8:AA9").Select
ActiveCell.FormulaR1C1 = ""
Range("C16:E16").Select
ActiveCell.FormulaR1C1 = ""
Range("C22").Select
End Sub