dmkitz
02-05-2007, 09:59 AM
I am using this code to insert a row above and merge some of the cells of that row:
Dim Rw As Long, Cels As String
Selection.EntireRow.Insert
Rw = ActiveCell.Row
Cells(Rw, 1).Activate
Range(Cells(Rw, 1), Cells(Rw, 4)).MergeCells = True
The row that the code adds is always formatted so that the cells are locked. What should I add so that the cells will not be locked or hidden? Thanks.
Dim Rw As Long, Cels As String
Selection.EntireRow.Insert
Rw = ActiveCell.Row
Cells(Rw, 1).Activate
Range(Cells(Rw, 1), Cells(Rw, 4)).MergeCells = True
The row that the code adds is always formatted so that the cells are locked. What should I add so that the cells will not be locked or hidden? Thanks.