Deleting Cells

MDTyKe · Mar 30th, 2004, 09:47 AM

Heym

Is it possible to delete cells, like the contents of them, without actually deleting the formatting of them:

Atm I have:

Rows("6:22").Select
Selection.Delete Shift:=xlUp
Range("C6").Select

Any ideas?

Thanks in advance,

Matt

fairwinds · Mar 30th, 2004, 09:49 AM

Hi,

Selection.ClearContents

Mar 30th, 2004, 09:47 AM	#1
MDTyKe Join Date: Feb 2004 Posts: 46	Deleting Cells Heym Is it possible to delete cells, like the contents of them, without actually deleting the formatting of them: Atm I have: Rows("6:22").Select Selection.Delete Shift:=xlUp Range("C6").Select Any ideas? Thanks in advance, Matt

Mar 30th, 2004, 09:49 AM	#2
fairwinds MrExcel MVP Join Date: May 2003 Posts: 8,456	Re: Deleting Cells Hi, Selection.ClearContents __________________ "Fair Winds and Following Seas"

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode