Re: $$Excel-Macros$$ Help urgently required for objective

2010-03-27 Thread C.G.Kumar
Thanks Ajay. On Fri, Mar 26, 2010 at 5:45 PM, Ajay Varshney wrote: > Here are the codes for your first five objectives: > > 'Objective 1 > Sub Delete_rows_above_headings() > Rows("1:12").Select > Range("A1").Activate > Selection.Delete Shift:=xlUp > Range("A1").Select > End Sub >

Re: $$Excel-Macros$$ Help urgently required for objective

2010-03-26 Thread Ajay Varshney
Here are the codes for your first five objectives: 'Objective 1 Sub Delete_rows_above_headings() Rows("1:12").Select Range("A1").Activate Selection.Delete Shift:=xlUp Range("A1").Select End Sub 'Objective 2 Sub Delete_Blank_Columns() Range("A1").Select i = 1 a = Workshe

Re: $$Excel-Macros$$ Help urgently required for objective

2010-03-26 Thread Vikas Chouhan
Hi Dear all, *Please help in access* it a urgent On Fri, Mar 19, 2010 at 10:45 AM, C.G.Kumar wrote: > Dear Masters, > > > File attached for your kind consideration and support.Please let me know > whether the objective from Sl No.6 onwards is possible to achieve or not. > > > Regards, > > C.G.Ku

Re: $$Excel-Macros$$ Help urgently required..

2010-03-17 Thread C.G.Kumar
Thanks Dave for your valuable comment but i am not able to achieve the objective based on user input as explained in earlier mail. Hope now you could provide the solution. Regards, C.G.Kumar On Thu, Mar 18, 2010 at 7:43 AM, Dave Bonallack wrote: > Hi, > I suggest you do all this with the mac

RE: $$Excel-Macros$$ Help urgently required..

2010-03-17 Thread Dave Bonallack
Hi, I suggest you do all this with the macro recorder turned on, then use the result as a starting point for your macro. You may even find that it needs no changing at all. Regards - Dave. Date: Wed, 17 Mar 2010 16:24:44 +0530 Subject: $$Excel-Macros$$ Help urgently required.. From: kumar.