Hi, I'm a beginner for Excel VBA.
What I want to do is to take out the first 15 characters in column C,
and copy the rest to clumn A. I have the following code, but VBA don't
recognize substitute funciton. Help....

Cells(n, 1).Value = Substitute(Cells(n, 3).Value, Left(Cells(n,
3).Value, 15), "", 1)

In VBA, it is Replace

Replace(expresssion, find_waht, replace_with)

--
HTH

Bob Phillips

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Angry Little Asian Bitch" wrote in message
ups.com...
Hi, I'm a beginner for Excel VBA.
What I want to do is to take out the first 15 characters in column C,
and copy the rest to clumn A. I have the following code, but VBA don't
recognize substitute funciton. Help....

Cells(n, 1).Value = Substitute(Cells(n, 3).Value, Left(Cells(n,
3).Value, 15), "", 1)