Inserting Column Based On Text

[Justinbodden]

Hi All-

Can someone please help to get VBA code to find specific text in row and insert column after the specific text.

Find Text : "Country"

Thank you!

JB

[mancubus]

try


With Worksheets("MySheet") 'change MySheet to suit
.Columns(.Cells.Find("Country").Column + 1).Insert
End With


because other arguments of the range.find method not stated, 'find' uses the defaults and finds the first occurence of "country" in worksheet.

more on find method:
https://msdn.microsoft.com/en-us/library/office/ff839746.aspx

[Justinbodden]

Thanks so much bro!