Simple Macro Needed..,

[rajuctech]

Hi Guys,
below mentioned format needed in excel ,using simple macro

enter the No:5 (If am enter 5 below result will shown)

Column A Column B Column C Column D Column E
5
4 4
3 3 3
2 2 2 2
1 1 1 1 1

Suggest me....

Best Regards
Raju

 

[daverunt]

Sorry Raju,

read your post totally wrong there.

Jonmo1 can youn explain what Application.Rept does?

 

[Jonmo1]

REPT = Repeat

Rept(string, #oftimes)

Repeats the given string, the given number of times..

Rept("a",5) = aaaaa
Rept("z",3) = zzz
Rept("Hello",2) = HelloHello


Hope that helps.

 

[daverunt]

Thanks.