Sleeper: @ mdmackillop..need further help on previous request.

[Tinku]

Hi mdmackillop

I am sorry if I am breaking rules here.. but you created this macro for me
so I thought it would be easy for you. I want to add one more extra step
to the macro you made.
The formula in column AA should be inserted before running the macro you created.

I am referring to this post

http://www.vbaexpress.com/forum/showthread.php?t=3781

Please let me know if this makes sense.

Regards
Tinku

[Tinku]

Hi Can anybody else help me with this request. I was hoping mdmackillop wuld help me with this as he did a wonderful macro and I just want to add one more little step to what he had done..but it seems he is on vacation. I can explain my request if mdmackillop is unavailable if anybody else is willing to help.

Regards
Tinku

[mdmackillop]

Hi Tinku,
Just seen your post. I'll have a look at it shortly.

[mdmackillop]

Hi Tinku
Add the following lines after End With as follows


End With
'Write formula into column AA and fill down
Cells(MyStart + 9, "AA").FormulaR1C1 = "=IF(RC[-20]+RC[-19]>0,""SMB"",""ENT"")"
Cells(MyStart + 9, "AA").Range("A1:A" & MyEnd - MyStart - 8).FillDown