View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kelly[_9_] Kelly[_9_] is offline
external usenet poster
 
Posts: 13
Default If then else assistance - conditional "deletion"

Hi all,

I'm trying to write a macro that looks in a given column of data for two
asterisks (**), for instance. If this macro encounters a cell with **
anywhere within its contents, it should delete the entire contents of
the cell including the asterisks. I need the desired column of data to
be user defined as well.

Does anyone know how I would go about creating this?

Any advice would be appreciated.

Many thanks,

Kelly



*** Sent via Developersdex http://www.developersdex.com ***