Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
dpb dpb is offline
external usenet poster
 
Posts: 109
Default Clear Area Except Formulae

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

--
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,872
Default 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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 07:05 PM
Clear formulae Stuart[_5_] Excel Programming 17 May 8th 04 11:19 AM


All times are GMT +1. The time now is 01:16 PM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"