If you have already selected the range, then
Selection.ClearContents
or
Range("B4:AA20").ClearContents
You can find a lot of macro commands by just recording a macro via Tools,
Macros, Record (pre 2007 command)
Robert Flanagan
http://www.add-ins.com
Productivity add-ins and downloadable books on
VB macros for Excel
"LiAD" wrote in message
...
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