 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / July 2006how to get formula content of a cell?
For example A1: =b2+c2, result is 5 I'd like to get "=b2+c2", not 5, without VBA. Thank you. Press Ctrl and ` together (key to the left of 1 on the left side of the keyboard), Regards, Alan. > For example > [quoted text clipped - 3 lines] > > Thank you. Thank you. What I really want is to reference to the formula in another cell. > Press Ctrl and ` together (key to the left of 1 on the left side of the > keyboard), [quoted text clipped - 8 lines] > > > > Thank you. > For example > > A1: =b2+c2, result is 5 > > I'd like to get "=b2+c2", not 5, without VBA. Tools/ Options/ View: Formulas  SignatureDavid Biddulph I interpreted this differently than the other 2 responders to your question. If my interpretation is correct, there is absolutely no way (that I know of) to get the formula contents of a cell (returned into another cell; this is where my interpretation differs,) without using VBA. I qualified my answer to include the phrase that I know of just in case. Due to the slight possibility that someone will pipe up with an answer that I never heard of. But if such a solution exists, I wonder why I haven't heard of it before. SignatureKevin Vaughn > For example > [quoted text clipped - 3 lines] > > Thank you. You interpret right. That's why I ask in worksheetfunctions group. Thank you. > I interpreted this differently than the other 2 responders to your question. > If my interpretation is correct, there is absolutely no way (that I know of) [quoted text clipped - 15 lines] > > > > Thank you. Muster, I know you said "no VBA", but this might help to address your question: http://www.mvps.org/dmcritchie/excel/formula.htm Beege > For example > [quoted text clipped - 3 lines] > > Thank you. Muster, Found this, too... and no VBA http://www.mcse.ms/archive144-2005-5-1637686.html Beege > For example > [quoted text clipped - 3 lines] > > Thank you. Thank you. > Muster, > [quoted text clipped - 11 lines] > > > > Thank you. muster, you/re welcome... Beege > Thank you. > [quoted text clipped - 13 lines] >> > >> > Thank you. I'm glad I qualified my answer. However, I believe that there is a potential problem with this solution. I tested it and it did work, however, this is probably a function leftover from Excel's previous macro language (the name of which escapes me, something like xmla,) which I have read can cause (I believe) a crash if copied to other worksheets in certain versions of Excel (something like that.) If someone reads this and knows the exact scenario, hopefully they'll respond with the specifics. SignatureKevin Vaughn > Muster, > [quoted text clipped - 11 lines] > > > > Thank you. From XL02 forward, the bug was fixed. I've used it in past versions, although not on any WB that was put on the LAN. Can never trust users to listen to, and follow instructions, especially pertaining to fatal consequences. In fact, I've suggested it's use in a post just today, but prefixed it with the caveat of pre-XL02 usage. SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > I'm glad I qualified my answer. However, I believe that there is a > potential [quoted text clipped - 23 lines] >> > >> > Thank you. The bug was fixed so it wouldn't crash but I believe you can't copy the formula to another sheet SignatureRegards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com > From XL02 forward, the bug was fixed. > [quoted text clipped - 34 lines] >>> > >>> > Thank you. AFAIK Peo, *everything* was fixed! Copying from WB to WB is no longer a problem. SignatureRegards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- The bug was fixed so it wouldn't crash but I believe you can't copy the formula to another sheet SignatureRegards, Peo Sjoblom Excel 95 - Excel 2007 Northwest Excel Solutions www.nwexcelsolutions.com > From XL02 forward, the bug was fixed. > [quoted text clipped - 33 lines] >>> > >>> > Thank you. Thanks. So I would still be affected as I am still using 2000. SignatureKevin Vaughn > From XL02 forward, the bug was fixed. > [quoted text clipped - 33 lines] > >> > > >> > Thank you. You would cause XL to crash *IF* you attempted to *COPY* the formula to another WB. Using it is *not* a problem. Creating (re-writing) it in another WB is *not* a problem. It has it's place when used properly in the pre-XL02 versions. SignatureRegards, RD ---------------------------------------------------------------------------- ------------------- Please keep all correspondence within the Group, so all may benefit ! ---------------------------------------------------------------------------- ------------------- Thanks. So I would still be affected as I am still using 2000. SignatureKevin Vaughn "Ragdyer" wrote: > From XL02 forward, the bug was fixed. > [quoted text clipped - 32 lines] > >> > > >> > Thank you. Ah. It's copying to another workbook? For some reason, I was under the impression that it was copying to another worksheet that was the problem. Thanks. So far I haven't felt like testing it (to the extent of trying to make Excel crash.) SignatureKevin Vaughn > You would cause XL to crash *IF* you attempted to *COPY* the formula to > another WB. [quoted text clipped - 47 lines] > > >> > > > >> > Thank you. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.