Re: $$Excel-Macros$$ Re: Macro Require

2013-08-07 Thread ashish koul
see if it helps On Wed, Aug 7, 2013 at 4:33 PM, wrote: > > > On Thursday, June 27, 2013 6:30:36 PM UTC+5:30, vikas khen wrote: >> >> >> Dear All, >> >> >> Please find the excel sheet. I need macro for the same >> >> >> >> Regards >> > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And

$$Excel-Macros$$ Re: Macro Require

2013-08-07 Thread sandeepsharma4759
On Thursday, June 27, 2013 6:30:36 PM UTC+5:30, vikas khen wrote: > > > Dear All, > > > Please find the excel sheet. I need macro for the same > > > > Regards > -- 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 Faceboo

Re: $$Excel-Macros$$ Re: Macro require

2013-01-30 Thread Bé Trần Văn
Another way that can help you Sub Statistics_sheetname() Dim i As Integer For i = 1 To ActiveWorkbook.Sheets.Count ActiveSheet.Range("a" & i).Value = Sheets(i).Name Range("a" & i).Select Next i End Sub 2013/1/30, Prince : > Hi Amir, > hope this can be help full for you. > > Sub test() > Dim

$$Excel-Macros$$ Re: Macro require

2013-01-30 Thread Prince
Hi Amir, hope this can be help full for you. Sub test() Dim wks As Worksheet Dim introw As Integer introw = 1 For Each wks In ThisWorkbook.Worksheets Sheet1.Cells(introw, 1).Value = wks.Name introw = introw + 1 Next End Sub regards Prince On Wednesday,