Posted to microsoft.public.excel.programming

Lacey

external usenet poster

Posts: 26

R1C1 Problem

Hi!

I have a macro that pastes a set of formula in a spreasheet and I'm
receiving an "End of Statement" error when the macro runs. The code looks
like this:

Range("B2").Select
ActiveCell.FormulaR1C1 = _

"=IF(("A2")<("A3"),""000"",IF((MID(E2,3,1))=""S"" ,(MID(E2,5,3)),""000""))"

Where I'm trying to compare cell A2 < A3, etc., etc. Why doesn't it like
this???

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
R1C1 and A1 style conflict in formula problem	mikeb	Excel Programming	9	November 7th 06 07:44 PM
UserForm R1C1 problem	WinterCoast	Excel Programming	4	June 9th 05 09:34 PM
Range R1C1 notation & the problem with my Macro	skiptabor	Excel Programming	2	May 31st 05 02:05 PM
looping formula - r1c1 problem - Con't	MDC[_2_]	Excel Programming	0	October 22nd 03 11:42 PM
looping formula - r1c1 problem	MDC[_2_]	Excel Programming	2	October 22nd 03 11:13 PM

All times are GMT +1. The time now is 08:45 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us