View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
watchtower watchtower is offline
external usenet poster
 
Posts: 25
Default Macro Looks for Cell Contents & Performs Action

I am trying to create a Macro in Excel that looks at the text in each cell in
column A:

-if the cell begins with " D" (three spaces and a D) then I need to cut
the cell and paste it up one row and right one column, then delete the row
from which it came

-if the cell does not begin with " D", then move down one cell

The loop should end when a cell contains "***"

This seems pretty easy, but I'm new to VBA...

Thanks,
Adam