The 'clear' instruction in VBA

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Clear Format problem 2
VBA set thick borders around non empty cells in range 0
how to clear my content in cells but keep the conditional formatti 1
clear cells on open 8
Conditional Formatting macro: simple, but doesn't work 6
Clearing Merged Cells 4
Clear Function 1
HDMI is a terrible format and I wish it never existed 2

Back
Top