View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
PointerMan PointerMan is offline
external usenet poster
 
Posts: 33
Default Macro to insert a cell after the selected cell

I have a huge database filled with data similar to the following set:

SCR SAW PI A HF RF
SCR SAW PI RF PI SCR
SCR SAW PI A HF RF
SCR SAW PI A HF RF

I'm looking for a macro that will prompt me for an input (ex. "SAW") and an
output (ex. "DB"). It would find every cell that contains the letters "SAW"
and insert a cell immediately to the right of it that contains the letters
"DB".