Thread: Clear formulae
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default Clear formulae
Hi
try
activecell.value=activecell.value

or something like
range("A1:A10").value=Range("A1:A10").value


--
Regards
Frank Kabel
Frankfurt, Germany


Stuart wrote:
Is there a simple way to clear formulae from the activesheet, leaving
just the values in the cells ..... or do I have to do this cell by
cell eg: setValue = ActiveCell.Value
ActiveCell = setValue

Regards.



---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.674 / Virus Database: 436 - Release Date: 02/05/2004

Reply With QuoteReply With Quote