larallaral Creative Commons License 2019.07.02 0 0 33018

Igen, az üresek írhatóak, illetve még két blokk:

 

Sheets("EUS BANK 2019").Select
ActiveSheet.Unprotect
Columns("A:AQ").Select
Selection.Locked = True
Selection.FormulaHidden = False
Range("C135:AL144").Select
Selection.Locked = False
Selection.FormulaHidden = False
Range("C152:AL204").Select
Selection.Locked = False
Selection.FormulaHidden = False
Range("A1").Select
Selection.SpecialCells(xlCellTypeBlanks).Select
Selection.Locked = False
Selection.FormulaHidden = False
Sheets("EUS BANK 2019").Select
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

Előzmény: Törölt nick (32987)