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!