Re: paste special - formulas

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: "Niek Otten" <nicolaus@xxxxxxxxx>
Date: Wed, 1 Feb 2006 12:38:12 +0100

No, that is not the intention. What you require can be achieved via Edit>Go 
to>Special, check Formulas and then copy and paste.

-- 
Kind regards,

Niek Otten

"bjw10" <bjw10@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message 
news:EC936D6B-994A-4546-B83D-6FA91F7734FA@xxxxxxxxxxxxxxxx
>I thought the intention behind Paste Special - Fomulas was to copy across
> only the contents of cells that contain a fomula (i.e. begins with an '='
> sign) and NOT those that contain a value. Have I got this wrong? It 
> certainly
> doesn't work that way for me since both formulas and values appear in the
> paste area. 


.

Prev by Date: Re: How do I get a count of dates within a range..?
Next by Date: Re: Adding months to dates should account for 28-30-31 day months
Previous by thread: Re: Adding hours minutes and seconds
Next by thread: Re: paste special - formulas
Index(es):
- Date
- Thread

Relevant Pages

Re: A Role Ms. Jenkins Can Really Sink Her Teeth Into
... Anyway if I did say it would spoil it for you and I have no intention ... Kind regards, ... Alan M. Watkins ...
(rec.music.opera)
Re: How do I do the inverse of tan in Excel?
... Hopefully we get some sort of feedback to see what the intention was ... Kind regards, ...
(microsoft.public.excel.worksheet.functions)
Re: ANN: DFM Check 1.1
... Appologies to "foul" your announcement btw, ... my intention. ...
(borland.public.delphi.thirdpartytools.general)
Re: Overriding interface members
... I can't imagine that this was the intention by the C# ... language developers... ... Kind regards, Sebastian ...
(microsoft.public.dotnet.languages.csharp)