Posted to microsoft.public.excel.programming

Slohcin

external usenet poster

Posts: 10

ActiveCell.FormulaR1C1

I have the following lines in my code:

ActiveCell.FormulaR1C1 = "=IF(RC[6]=""AA"",""ST"",""EA"")"
Range("D2").Select

This sets the value of one cell to ST if another equals AA, if not it sets
the value to EA. I have now found that AA may be AA or AB or AX but I still
need the second cell to be set to ST or EA, how do I do this?
--
Thanks
Slohcin

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
ActiveCell.FormulaR1C1	Rick	Excel Discussion (Misc queries)	3	March 28th 10 10:36 PM
ActiveCell.FormulaR1C1	SteveDB1	Excel Programming	4	March 28th 08 02:55 PM
ActiveCell.FormulaR1C1	PapaDos	Excel Programming	0	December 7th 06 07:06 AM
ActiveCell.FormulaR1C1	Tom Ogilvy	Excel Programming	0	December 6th 06 08:03 PM
ActiveCell.FormulaR1C1	Leif Rasmussen	Excel Programming	1	October 16th 03 09:46 AM

All times are GMT +1. The time now is 07:05 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us