Livin404
Well-known Member
- Joined
- Jan 7, 2019
- Messages
- 743
- Office Version
- 365
- 2019
- Platform
- Windows
Greetings, I've completed this project after 38 macros. It all works fine. There is just one cosmetic thing I would like to sort out. When I'm finished "Run All", there is a huge part of my worksheet that is greyed out (it looks like it has been selected). I would like the cell containing "UPDATED BY:" selected. This way I don't have to randomly click anywhere just to clear out the grey area of my worksheet. I figured I can put in just a brief line into the last macro- please see below. Thank you,
VBA Code:
Sub ACV_LOCAL()
Dim i As Long
For i = 1 To ActiveSheet.Cells(Rows.Count, 2).End(xlUp).Row
Select Case ActiveSheet.Cells(i, 1).Value
Case "ACV(EUREKA/ARCATA, CA)"
ActiveSheet.Range("F" & i) = "EXPECT TO STEP/LOCAL/DON'T POST"
ActiveSheet.Range("E" & i) = "N/A"
End Select
Next i
End Sub