Need a help to write formula in macro

[nareshmedarmatila]

Hi I'm new here! sorry if I'm posting this in wrong place!

I need a small help regarding a code

I have data in Column A i need to write formula in column B
Formula is =len(A2)

i need the formula to be in column B only if column A has data.

I'm posting example image here.

 

[footoo]

Range("A2:A" & Cells(Rows.Count, "A").End(3).Row).SpecialCells(xlCellTypeConstants).Offset(, 1).Formula = "=LEN(A2)"

Note : your sample data did not start at A2

 

[nareshmedarmatila]

Range("A2:A" & Cells(Rows.Count, "A").End(3).Row).SpecialCells(xlCellTypeConstants).Offset(, 1).Formula = "=LEN(A2)"

Note : your sample data did not start at A2

what if I need to use this forumla in column C or Column D?


by the way code is working in Column B!

 

[nareshmedarmatila]

worked in C by changing this
SpecialCells(xlCellTypeConstants).Offset(, 2).Formula