Posted to microsoft.public.excel.misc

Claus Busch Claus Busch is offline

external usenet poster

Posts: 3,872

Clear Area Except Formulae

Hi Duane,

Am Wed, 19 May 2021 12:45:59 -0500 schrieb dpb:

Is there a way to select a range and clear all content not a formula in
that range?

e.g.:
Range("A1:C10").SpecialCells(xlCellTypeConstants). ClearContents

Regards
Claus B.
--
Windows10
Microsoft 365 for business

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
File, print area, clear area, is not working	cblind	New Users to Excel	2	September 12th 07 04:51 PM
When I clear a print area, it still prints.	AngelaArdettoMicrosoftOfficeExcelWorkshe	Excel Worksheet Functions	2	June 23rd 06 08:29 PM
Can't Clear Print Area	GeorgeF	Excel Discussion (Misc queries)	2	August 5th 05 06:10 PM
How do I clear the formating of the area OUTSIDE my chart on my w.	workinggirl	Excel Discussion (Misc queries)	0	January 27th 05 06:05 PM
Clear formulae	Stuart[_5_]	Excel Programming	17	May 8th 04 11:19 AM

All times are GMT +1. The time now is 10:39 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us