View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Flanagan[_2_] Bob Flanagan[_2_] is offline
external usenet poster
 
Posts: 81
Default Simple delete macro

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