Looping issues with a For statement

[DeanMcK]

Hi All,

Trying to get a loop to through cells with a For statement.

This works for me without the For statement

Please Login or Register  to view this content.

I need to convert to something like this

Please Login or Register  to view this content.

I need to convert it to work with the For statement below

Please Login or Register  to view this content.

Any help appreciated

Cheers

Dean

[alansidman]

Please Login or Register  to view this content.

[DeanMcK]

Hi Alan,

Thanks for the help,

comes back with a syntax error

ws.Range("C" & i).Formula = "=LEFT(ws.Range("A" & i),(FIND(""."",Range("A" & i),1)-1))"

[alansidman]

Need double quotes inside a quoted statement, so.....

Please Login or Register  to view this content.

[DeanMcK]

Thanks Alan

I used the updated code above and this is the result I get in the formula bar once run with #NAME? error. Still not working

Please Login or Register  to view this content.

[DeanMcK]

Hi Alan,

Persistence is a virtue. I got it to work

Please Login or Register  to view this content.

Thanks for your help.

Cheers

Dean