Posted to microsoft.public.excel.programming

external usenet poster

Posts: 24

error

Hi
I cannot get this to work.......
Range("F19").Select
ActiveCell.FormulaR1C1 = "=IF(OR(FRM100!
M16="Fail",FRM100!M18="Fail",FRM100!M20="Fail",FRM 100!
M22="Fail",FRM100!M25="Fail",FRM100!M30="Fail",FRM 100!
M44="Fail",FRM100!M55="Fail",FRM100!M60="Fail",FRM 100!
M62="Fail"),"FAIL","PASS")"
thanks
Jo

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
Excel 2007 - error saving file & error loading dll	TinaF	Excel Discussion (Misc queries)	0	July 1st 09 01:49 PM
Counting instances of found text (Excel error? Or user error?)	S Davis	Excel Worksheet Functions	5	September 12th 06 04:52 PM
I have Error 1919 Error Configuring ODBC dataSource Database	Texanna1	Excel Discussion (Misc queries)	1	September 12th 06 06:35 AM
Error 50290: Error writing to Worksheet while using an ActiveX Control	emblair3	Excel Programming	3	February 24th 04 06:03 PM

All times are GMT +1. The time now is 07:50 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us