PDA

View Full Version : sequential number



Hummer
08-30-2006, 08:16 AM
Hi!

I want to use VBA to generate consecutive Numbers inside a List and within a single column.

Who can help? Maybe its too easy...

Thanks in advance!
Hummer

Zack Barresse
08-30-2006, 08:22 AM
Hello Hummer, welcome to VBAX!

Can you be a little more specific? Do these need to be whole numbers? Starting at one (1)? Ending at what? Put a number in every consecutive cell? Which column? Starting at what cell? Any other parameters?

Hummer
08-30-2006, 08:28 AM
Hello Hummer, welcome to VBAX!
Do these need to be whole numbers?
-->yes positive Numbers, starting with "1"; i want to put smth like a "pos"-no. to my list

Starting at one (1)?
-->see above

Ending at what?
-->with the last item imported from the XML-Data into the List

Put a number in every consecutive cell?
--> yes
Which column?
--> A

Starting at what cell?
--> A27
Any other parameters?
-->not so far...



Thanks for your help!

Zack Barresse
08-30-2006, 08:34 AM
Okay, one more question, what determines your last cell? Should it be based on another columns data?