Find a specific text item and manipulate cells surrounding

Tech-Archive recommends: Fix windows errors by optimizing your registry

Hello

Sorry for being rubbish but despite other examples i am still struggling. I
have the string "hello" as a column heading in a ***. I wish to create a
macro that, for every time is run, assigns the cell value (eg A3 if "hello"
is in A3) to a variable.
i then have the code;

Range("A3").Select <--- "A3" will become the variable
Selection.EntireColumn.Insert

to insert a new column.
When the macro is re-run, the variable would hold the range "A4" in this
instance, and move the string "hello" into cell A5.

Thank you
.

Quantcast