If with LEN (formula)

[Philip00]

Hi All,

I would like to make and IF function in VBA, i have tried with this one with no luck:

If len activecelloffset(0,0) >=36 then ....

Can somebody help me to make this if function work?

Thank you so much in Advance

 

[FormR]

Hi, It should look more like this..

If Len(ActiveCell.Value) >= 36 Then

 

[Philip00]

Hi, It should look more like this..

If Len(ActiveCell.Value) >= 36 Then

Thank you so much !!!