Hello,
I am looking to write a VBA program to search a column for a particular string "Jeff" and when that string is found to copy the entire row to the row below on the same worksheet and highlight the font in red. Thank you in advance.
The code below does it for the first row found but does not look to any rows below that. I am assuming a loop? Thank you in advance
Option Explicit
Sub Macro2()
Dim rngAddress As Range
Dim rowToBeCopied As Integer
Set rngAddress = Range("B:B").Find(";")
If rngAddress Is Nothing Then...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.