Posted to microsoft.public.excel.worksheet.functions

Co-op Bank

Posts: n/a

Changing Formula elements to values

Hello, is there a way to change a formula for example '=a1+a2+a3' to show its
constant values instead in the cell so it would show '=10+20+30' assuming
'a1' = 10 etc...

Would this be a VBA solution? Any help suggestions would be much appreciated.

Regards
Brian
Manchester, England

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula Problem - interrupted by #VALUE! in other cells!?	Ted	Excel Worksheet Functions	17	November 25th 05 05:18 PM
I Need a formula to evaluate a cell with + or - values	Bob in Oklahoma	Excel Worksheet Functions	6	October 31st 05 02:41 PM
Keep formula from changing?	Fred Holmes	Excel Worksheet Functions	2	October 14th 05 05:21 PM
Formula to compare multiple rows values based on another column?	Murph	Excel Worksheet Functions	4	February 21st 05 02:44 AM
manipulating formula values	Ramy	Excel Worksheet Functions	4	November 19th 04 04:54 PM

All times are GMT +1. The time now is 11:14 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us