Posted to microsoft.public.excel.programming

Bony Pony[_2_] Bony Pony[_2_] is offline

external usenet poster

Posts: 71

Formulas containing hard coded values

Hi all,
I am in receipt of a workbook in which someone has "amended" random formulas
with harcoded additions - eg
=a1*b1*1.7
or
=if(a1=0,"None,"OK")

Does anyone have a vba approach to identify a cell that contains hardcoded
numbers or text?

Thanks in advance!
Bony

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
Convert Hard-coded cell values to constants	Takeadoe	Excel Discussion (Misc queries)	2	May 20th 06 12:59 AM
hard coded text	William Benson[_2_]	Excel Programming	2	July 6th 05 06:40 PM
Input Values Instead of Hard Coded Values	Paul Black	Excel Programming	4	November 28th 04 11:15 AM
References to open/hidden workbooks become hard-coded in formulas - 2003	L Mehl	Excel Discussion (Misc queries)	2	November 27th 04 09:28 PM
References to open/hidden workbooks become hard-coded in formulas- 2003	Larry Mehl	Excel Programming	1	November 27th 04 11:15 AM

All times are GMT +1. The time now is 01:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us