Proper syntax with formula in VBA

This is a line from a VMA module I use.

It's failing because I am not entering the concatenate properly and I'm not sure what the syntax should be.

Please Login or Register  to view this content.

The part of the code that's failing is where I am trying to concatenate "000" and the contents of 2. It would look like 0001234567.

Thank you...This is the first time I've tried to concatenate in VBA.

Ken

Couple of things wrong.

First, your formula has two "(" and three ")", so that will fail.

Second, as you are experiencing, there is a trick to adding " within a string. The trick is to use ""

So,

Please Login or Register  to view this content.

Hi

Range("C2:C" & last_row).Formula = "=IF(LEN(K2)=10,K2,""000""&K2)"