Imam problem z odpiranjem DZ in izbiro določene celice. Javi mi napako "Metoda Select razreda Range ni uspela"Kje bi bila napaka, list ni zaklenjen.
Makro se zaustavi pri vrstici "Range("J3").Select"
Hvala za pomoč in LP
Koda: Izberi vse
Private Sub cmdDodaj_Click()
Range("B2").Select
ActiveCell.FormulaR1C1 = "234"
'Range("B2").Select
Selection.Copy
Workbooks.Open Filename:= _
"d:\Moji dokumenti\Del. nalogi\DN.xltx", UpdateLinks:=3, _
Editable:=True
Sheets("Test").Select
Range("J3").Select
ActiveSheet.Paste
Application.CutCopyMode = False
ActiveWorkbook.Save
ActiveWindow.Close
End Sub