Converting text to autonumber.

[wheatless12]

Heya,

I recently made a simple macro to parse through an excel sheet, and create a word document. We have to do this pretty often, the macro is helpful. The output essentially looks like this:

1. Stuff from column K.

Response:

It then loops through all of the k's. This is great, except for one thing that is driving me crazy. I need the numbers in front (1. , 2. , 3.) to be outline numbers. Right now they are just text. So, in other words I need them all to be automatic so that if need to enter another thing between 1. and 2., 2. becomes 3. Any ideas? I thought if I put a space after the number it would automatically do it, just like it would if you entered it in word. That hasn't worked though, along with multiple other attempts

Please Login or Register  to view this content.