Re: Coping formulas to new workbook

If you don't enter or escape after the copy, you're still editting the cell with
the original formula.

And I agree that it's a matter of preference. I like to select the whole
formula. I find it easier to swipe the whole formula than positioning the
cursor after the equal sign.

Dave wrote:
>
> No, I didn't click the = sign, but it does work using your revised
> instruction. Hitting "Esc" drops the reference to the original cell
> when pasting into the new one. Following adeel's (10th posting) method
> results in =A3=SUM(C1+D1) where A3 is the destination cell for me. As
> you can probably see, without hitting Esc your method still carries
> over the first formula. As for your method or mine, either requires the
> same number of mouse clicks and keyboard presses, so it's a matter of
> preference I guess.

--

Dave Peterson
.

Relevant Pages

  • Re: Using public members of a class inside the class
    ... object-oriented programming. ... functions and properties a matter of preference to a certain extent? ... 'End of Class module ...
    (microsoft.public.word.vba.beginners)
  • Re: unicycle for chirst
    ... All of the matter in our universe would have always had to ... In order for the first cell to evolve it would need a cell ... These spirits can effect what matter ... impossibilities over this logic is because we are afraid to admit there ...
    (rec.sport.unicycling)
  • Re: are you gradual, I mean, declaring with regard to dramatic biles
    ... and it means 'matter formatted by information'. ... information structures the balance. ... A single cell, in its DNA strands, holds a MASSIVE AMOUNT OF INFORMATION. ... The 'arousal filter' Stafford Beer and his cyberneticians ...
    (sci.crypt)
  • {human}I am gradually costly, so I flourish you.
    ... and it means 'matter formatted by information'. ... information structures the balance. ... A single cell, in its DNA strands, holds a MASSIVE AMOUNT OF INFORMATION. ... The 'arousal filter' Stafford Beer and his cyberneticians ...
    (rec.games.roguelike.nethack)
  • @@@@@ as inside as Ahmad bothers, you can show the independence much more all @@@@@
    ... The Sun as direct life-giver. ... On purpose, to sustain life. ... This property of matter to spontaneously become more complex is called ... A single cell, in its DNA strands, holds a MASSIVE AMOUNT OF INFORMATION. ...
    (sci.crypt)
Quantcast