Fill a row without overwriting existing cell data

[jmichalski81]

Hi -
I have a spreadsheet used for staffing with employee names in column D and the days of the year from column C through the end of the year. We have a weekly meeting and for employees that don't move to a different project, we use the fill handle to drag them across the row through the end of the following week. Some employees have pre-scheduled days off and we currently just fill across that and re-enter "off" for the day that was previously arranged to be off. Is there a way to keep certain cell values permanent so that the fill handle does not overwrite it?

 

[kennypete]

I'm not sure about your columns/description, but if you have a bunch of cells selected and want to fill the empty cells in that selection with something, in this example, "filled", you could use this:

Sub FillEmpty()

    Dim rng As Range
    Dim cll As Range

    Set rng = Selection

    For Each cll In rng.Cells
        If IsEmpty(cll) Then
            cll.Value = "filled"
        End If
    Next cll

End Sub

This leaves any non-empty cell alone, which sounds like your "keep certain cell values permanent"?