View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RichHoughton RichHoughton is offline
external usenet poster
 
Posts: 9
Default Find a specific text item and manipulate cells surrounding

Hello

Sorry for being rubbish but despite other examples i am still struggling. I
have the string "hello" as a column heading in a sheet. 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