Re: $$Excel-Macros$$ Codes for SubPart

2014-02-13 Thread Swapnil Palande
Hi Arvind, You can achive this using formula also. PFA excel. Regards, Swapnil. On Thu, Feb 13, 2014 at 1:17 PM, pankaj sangotra wrote: > Please try this hope this will help.. > > Sub output() > Dim i As Integer, k As Integer, j As Integer > k = 1 > For i = 1 To 5 > For j = 97 To 100 >

Re: $$Excel-Macros$$ Codes for SubPart

2014-02-12 Thread pankaj sangotra
Please try this hope this will help.. Sub output() Dim i As Integer, k As Integer, j As Integer k = 1 For i = 1 To 5 For j = 97 To 100 Cells(k, 1).Value = i & Chr(j) k = k + 1 Next Next End Sub On Thu, Feb 13, 2014 at 12:52 PM, arvind sharma Rajendra < arveensharm...@gmai

$$Excel-Macros$$ Codes for SubPart

2014-02-12 Thread arvind sharma Rajendra
hi ppl, i need help. for example my input day is 5 days. i need a code to show 1a 1b 1c 1d 2a 2b 2c . . . . . .5d in this orientation? is this possible? -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum