Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings, I got the VBA below with the help of "Fluff" from this website. Before I add "0000" to Column D I need to ensure the corresponding cell in Column C is NOT blank OR contains "N/A". Thank you.
VBA Code:
Sub Insert_Null()
With Sheets("72 HR")
Columns("D:D").NumberFormat = "@"
.Range("D2:D" & .Range("C" & Rows.Count).End(xlUp).Row).SpecialCells(xlBlanks).Value = "0000"
End With
End Sub