Is there a way to copy a formula result as the actual value and not the formula,
I can do copy and paste using "value" option but would like an automated formula or code option if possible.
In the example, D4 copies C4, would like D4 to show "AB" and not the formula "=C4"
Thanks
Last edited by junada0; 01-25-2010 at 04:20 AM.
In Excel Options, Advanced, Display option for this worksheet verify that the box for Show formulas.... is unchecked.
Ben Van Johnson
Not really what i am looking for, I would like to see the true value "AB" in D4 cell only (or any other cell) and not the formula
Sorry, the picture you posted indicates that you have "show formulas" selected. I was only trying to get you to verify that 'Show formulas" option is unchecked.
No Problem,
Understand your logic, I had used the apostrophe before the = sign to allow formula to be shown in the diagram, sorry for any confusion. '=CONCATENATE(A4,B4).
simple code is
Please Login or Register to view this content.
"Unless otherwise stated all my comments are directed at OP"
Mojito connoisseur and now happily retired
where does code go ?
look here
how to insert code
how to enter array formula
why use -- in sumproduct
recommended reading
wiki Mojito
how to say no convincingly
most important thing you need
Martin Wilson: SPV
and RSMBC
No need to loop
For a single cell you can enter =C4 in the cell D4 and press F9 to convert formula to value.Please Login or Register to view this content.
Can I just clarify. Would this type of formulae allow me to to take a "snapshot" of a stock level at the end of each month and retain it in excel 2007 as an actual value?
Would suggest you try a sample report, and test.
Code works ok for my purpose, thanks for all your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks