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.
Hi Skip,
I actually do want two identical rows of data. I know it must not make sense but it is a file from an output source that is there is a semi colon in column B I need to make a copy of the line for importing into financial system. Thanks, sorry for the confusion.
Hi Skip,
I need to keep all data intact. I just need to copy the entire row in the row below when a semi colon is in the search string on column B. Thanks
Hello Skip,
Thank you for the advice. I am trying to write VBA code to determine if there is a ";" in column B of an Active worksheet, and if there is any cell with a semi colon ";" in column B to copy that cell to the row below. All of the information in that row would be copied.
Thank you.
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.