how to create star formats?

[yogesh aggarwal]

i am new in this forum and thanks for the administrators for maintaining a fantastic helping forum.

please help me how to create a programm in vba to create : Q1- how to create this star figure using vba
*
* *
* * *
* *
*
Q2- how to create the below programm in vba?

*
* *
* * *
* * *
* *
*
i am waiting for your replys.

[wamp]

I assume you want something like this.
(read code-comments for explanation (the example gives a starpattern of 1-2-3-2-1 in range A1:A5)

Please Login or Register  to view this content.

[yogesh aggarwal]

thanks for your help........excel forum rocks.........