Activecell = "=IF(LEFT(J3,1)=""1"",IF(AW30,""dated on " _
& " ""&AQ3,IF(AO30,""waiting"",INDEX($1:3,1,SMALL " _
& "(IF(AR3:AT30,COLUMN(AR3:AT3)),COLUMN(2:2)))) ))"
--
Best wishes,

Jim


"BubbleGum" wrote:

Hi,
I am not quite familiar with writing custom function in module, could you
help to convert the following excel formula?

=IF(LEFT(J3,1)="1",IF(AW30,"dated on
"&AQ3,IF(AO30,"waiting",INDEX($1:3,1,SMALL(IF(AR3 :AT30,COLUMN(AR3:AT3)),COLUMN(2:2))))))

Many thanks.