abc-us2, last number increasing....

[sharan.ashutosh]

Hello,

I got stuck with my macro for a minor issue.

Please see the code below-

Please Login or Register  to view this content.

When i run this code, value in c1 (abc-us2) should be populated for full C column untill there is a blank value in col A., but what I am getting is-
abc-us2
abc-us3
abc-us4
.
.
.
.
abc-us(n)

The last number '2' is increasing where as it should not.. Please help.

[HaHoBe]

Hi, sharan.ashutosh,

please wrap your code up in code-tags.

Please Login or Register  to view this content.

Ciao,
Holger

[GIS2013]

Hi, try this

Please Login or Register  to view this content.

oops The-expert has already answered you

[jeffreybrown]

or even...

Please Login or Register  to view this content.