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?
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.