Very quick question I hope.

I have a macro in which the following instruction appears:

Selection.Clear

The only problem is that everything is cleared, but in fact I want the
formatting of the cell to remain (for example, the borders, number
formatting, etc.).

If anyone can tell me how to adapt the instruction so that formatting
remain, that would be much appreciated.

Thanks

Mike

Use ClearContents instead of Clear.

--

Vasant

"Mike" wrote in message
...
Very quick question I hope.

I have a macro in which the following instruction appears:

Selection.Clear

The only problem is that everything is cleared, but in fact I want the
formatting of the cell to remain (for example, the borders, number
formatting, etc.).

If anyone can tell me how to adapt the instruction so that formatting
remain, that would be much appreciated.

Thanks

Mike

Cheers

Mike

"Vasant Nanavati" <vasantn *AT* aol *DOT* com wrote in message
...
Use ClearContents instead of Clear.

--

Vasant

"Mike" wrote in message
...
Very quick question I hope.

I have a macro in which the following instruction appears:

Selection.Clear

The only problem is that everything is cleared, but in fact I want the
formatting of the cell to remain (for example, the borders, number
formatting, etc.).

If anyone can tell me how to adapt the instruction so that formatting
remain, that would be much appreciated.

Thanks

Mike