I am guessing there isn't a possibility of this based on the purpose of .value;
But I am looking if there is a possibility of also taking the format on a .value = .value
I am trying to avoid a copy and paste
I have an example below
But I am looking if there is a possibility of also taking the format on a .value = .value
I am trying to avoid a copy and paste
I have an example below
Code:
Dim c As Range
For Each c In Range("A2:B" & ThisWorkbook.Worksheets("Sheet1").Cells(Rows.Count, "A").End(xlUp).Row)
If c.Value = "" Then c.Value = c.Offset(-1, 0).Value
Next c