invalid next control variable reference for looping

[alienalvan]

I get "invalid next control variable reference", can anyone tell me what's wrong with my script?

Please Login or Register  to view this content.

[JosephP]

You are missing a

Please Login or Register  to view this content.

line before the

Please Login or Register  to view this content.

[alienalvan]

Come out with new error "Next without For"

Next without For.JPG

Please Login or Register  to view this content.

[JosephP]

You removed the For i loop!

[alienalvan]

Gosh! Sorry for my noobness

Btw, when i try to insert 1 more cell to change the value this error pops out.

Any idea? Thanks man!

Wrong Number.JPG

Please Login or Register  to view this content.

[JosephP]

what range are you trying to process? Range("f15", "c6") refers to all the cells from c6 down and across to f15 not just those two cells
Perhaps you want Range("d15,f15,c6") to just process three cells?

[alienalvan]

Yup, i only want those 3 cell value to be change.
Currently i put it this way, no error so far.
What's your opinions?

Please Login or Register  to view this content.

[JosephP]

That includes E15

[alienalvan]

oic, then it's ok coz no value will be added in E15

Btw, is there any way to reflect a value from A1 to B1 with additional symbols?

Example:

A1 = 1100

After reflect to B1

B1 = *1100*

Thanks in advance

[JosephP]

Yes you can concatenate those symbols with the value using the & operator or you could simply use a custom number format on the cell