K
Kelly
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
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