The easiest way to find out is to just run it

The first line puts the formula =K19/I19 into cell J19

The second line puts the formula =IF(I19<0,B19,$C$6) into cell M19

The sheet where these cells are located is given by the VBA variable
SheetNotification that must be defined somewhere.

Range("m" & 19) instead of Range("m19") looks strange, but does work.

Jerry

"FIRSTROUNDKO via OfficeKB.com" wrote:

HI,

can somebody please expalin in plain english what this lines of codes do

Worksheets(SheetNotification).Range("m" & 19).Value = "=IF(RC[-4]<0,RC[-11],
R6C3)"

Worksheets(SheetNotification).Range("j" & 19).Value = "=RC[1]/RC[-1]"

Thanks in Advance

Darren

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200603/1