Re: $$Excel-Macros$$ Code Automatically

2013-03-12 Thread Chaya
Awesome Anil sir, as i expected you have solved my query. Thanks all for assist. Thanks once again. Sir, Can you please explain me your coding. step by step so that i can understand: Dim a As Integer Set ws = Worksheets("2") Dim b As String irow = ws.Cells(Columns.Count).End(xlToLef

Re: $$Excel-Macros$$ Code Automatically

2013-03-12 Thread Abhishek Jain
I still did not get your query. I have manually done what your code is doing...the data is shifting down because you added 54 rows there, but that's not my point of concern. I also did not understand what you meant by you have to click 6000 times. All your code is doing is copy and paste. Same val

Re: $$Excel-Macros$$ Code Automatically

2013-03-11 Thread Chaya
Yes Sir, If you see the attached sheet, there one button is there, please click on that and go to second sheet. you will find that every time the datas are shifting down -Chaya On Tue, Mar 12, 2013 at 12:02 PM, Abhishek Jain wrote: > Can you also provide a sample output? > > > On Tue, Mar 1

Re: $$Excel-Macros$$ Code Automatically

2013-03-11 Thread Abhishek Jain
Can you also provide a sample output? On Tue, Mar 12, 2013 at 11:37 AM, Chaya wrote: > Dear Experts, > > Once more help please, i am a new learner in macros, i love it. right now > i am learning by only recording the macros in excel. even i don't know how > to declare vaue and solve the query.