Posted to microsoft.public.excel.programming

Abdul[_2_] Abdul[_2_] is offline

external usenet poster

Posts: 137

Change Formula in sheet by adding a new part

I have many formulas in a sheet like :

=ROUND('Revenue'!D$45*VLOOKUP($C116,ItemSplit!$A$1 :$B$50,2,FALSE),0)

If the the formula do not contain *Code!$C$47 (multiply by) at the end
of the formula i want to add it to all the formula in the sheet.

Can it be done using VBA or by find, replace function

Thanks

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
Can Sheet name be part of formula for a cell (+ sheet name)	Leslie	Excel Worksheet Functions	1	March 9th 10 06:28 PM
Adding Multi-part Formula	PhilosophersSage	Excel Discussion (Misc queries)	3	October 6th 09 06:37 PM
change part of hyperlink formula	Big Mac	Excel Discussion (Misc queries)	3	February 4th 09 02:07 PM
change color of all cells with formula or are part of a formula	[email protected]	Excel Discussion (Misc queries)	19	January 28th 08 01:21 AM
Change part of formula	[email protected]	Excel Worksheet Functions	2	October 8th 06 08:50 PM

All times are GMT +1. The time now is 12:30 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us