Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings. I can easily add text to a cell, but I have different macros in my project which potentially asks data to be placed in the same cell. I believe I will need something like an Else statement. The following macro works great on a blank cell. However, I would like it to have a // following the existing data if the cell is not empty. Thank You
VBA Code:
Sub Step_Truck()
Dim i As Long
For i = 3 To ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row
Select Case ActiveSheet.Cells(i, 3).Value
Case "B757", "B75720", "B7772E", "B7673E", "MD011F", "B76720", "B76730", "A400M"
ActiveSheet.Range("E" & i) = "EXPECT TO STEP"
End Select
Next i
End Sub