Hi,
I need to highlight the range from A to K where the Column G contains FB01. It will be great if somebody can help me with a VBA code. As I will append it after some existing code.
At present I am using this code but it's highlighting the entire row. Also it's taking a lot of time as I believe i am making some mistake.
Sub highlight()
Dim cell As Range
Range(Range("G1"), Range("H1").End(xlDown)).Select
For Each cell In Selection
If cell = "FB01" Then cell.EntireRow.Interior.ColorIndex = 4
Next cell
End Sub
Thanks for all your help.
Regards,me
Bookmarks