Re: $$Excel-Macros$$ need macro to generate serial no

2015-08-29 Thread My Excel
Thanks for reply sir, its done through macro & manually ( by dragging ) i waited 3 days no solution found just i did Sub SerialNo() With Range("A100:A" & Range("B" & Rows.Count).End(xlUp).Row) .Cells(1, 1).Value = 1000 .DataSeries Rowcol:=xlColumns, Type:=xlLinear, Step:=1, Tren

Re: $$Excel-Macros$$ need macro to generate serial no

2015-08-28 Thread Abhishek Jain
Your query is not clear...please elaborate. On Sat, Aug 29, 2015 at 9:24 AM, My Excel wrote: > any macro solution ? > > > On Thu, Aug 27, 2015 at 10:18 PM, My Excel wrote: > >> Sir, >> >> need help on serial no generate (like attached file) >> >> using auto increment loop >> >> start from 120

Re: $$Excel-Macros$$ need macro to generate serial no

2015-08-28 Thread My Excel
any macro solution ? On Thu, Aug 27, 2015 at 10:18 PM, My Excel wrote: > Sir, > > need help on serial no generate (like attached file) > > using auto increment loop > > start from 1200 to > > better if possible 1 crore in 1 sheet > thanks, > > -- > Are you =EXP(E:RT) or =NOT(EXP(E: