Delete cell data in a row
 

How can I use a macro to delete the cell data contained in a row except for
the data in Column A?

It must not delete the conditional formatting or validation settings or
formuals though (formulas are hidden and sheet is password protected -
already have macros to turn on and off password protection).

Thanks,

Nick

Delete cell data in a row
 

Nick,

See my latest reply to your post on 'inserting rows at bottom'.

Cheers


"Nick Smith" wrote in message
...
How can I use a macro to delete the cell data contained in a row except
for
the data in Column A?

It must not delete the conditional formatting or validation settings or
formuals though (formulas are hidden and sheet is password protected -
already have macros to turn on and off password protection).

Thanks,

Nick

Delete cell data in a row
 

thanks very much. spot on.

"macropod" wrote:

Nick,

See my latest reply to your post on 'inserting rows at bottom'.

Cheers


"Nick Smith" wrote in message
...
How can I use a macro to delete the cell data contained in a row except
for
the data in Column A?

It must not delete the conditional formatting or validation settings or
formuals though (formulas are hidden and sheet is password protected -
already have macros to turn on and off password protection).

Thanks,

Nick