Help with auto generating numbers (as a text) based on a value

[agl4]

Hi,

Can someone help me generating the VBA macro to accomplish this task?

What I want to acomplish is this.

On cell(B5)= CC90356
I would like to generate this text for 10 (this # will change!)
Final results:

Cell (B5) = CC90356
Cell (B6) = CC90357
Cell (B7) = CC90358
Cell (B8) = CC90359
Cell (B9) = CC90360
Cell (B10) = CC90361
Cell (B11) = CC90362
Cell (B12) = CC90363
Cell (B13) = CC90364
Cell (B14) = CC90365
Cell (B15) = CC90366

How can I write the VBA macro for that?
Thanks in advanced!

[judgeh59]

so this should work....you don't mention how you want to launch this, so it's very basic....also, if you don't need a VBA solution you can do this other ways....

Please Login or Register  to view this content.

[agl4]

Hi Judgeh59, your codes worked perfectly!! Thank you so much!!!

[judgeh59]

glad I could help and thanks for the rep point....please don't forget to set this thread to SOLVED...have a great day