Lovely,

I'd forgotten the simple way to record macros rather than writing code.

Thanks for the reminder.

"Mike H" wrote:

Hi,

At it's simplest this will do it

Range("B4:AA20").ClearContents

Be aware that this deletes everything in that range, if that's not what you
want then post back.

Mike

"LiAD" wrote:

Good afternoon,

Could somebody show me a simple macro please for how to delete entries in
cells.
I have text in cells B4-AA20 that I wanted to be able to delete by a macro.

Thanks
LD