Cliffork
New Member
- Joined
- Feb 12, 2020
- Messages
- 21
- Office Version
- 365
I'm trying to basically hide the text of 6 cells if there is a D at the end of cell B15. I've done this in VBA to hide entire rows before, but how the formatting needed to be for this particular page I can't hide the whole row. I need to just make the text invisible if a serial number ends in a D in B15.
My VBA code for a similar thing with the same reference is:
I'm just having a hard time wrapping my head around how to write this as a formula. Any ideas?
My VBA code for a similar thing with the same reference is:
VBA Code:
If Target.Address(0, 0) = "B15" Then
With Sheets("Final Insp.")
If Target.Value Like "*D" Or Target.Value Like "*d" Then
.Rows("43:48").Hidden = False