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
|