Re: $$Excel-Macros$$ Re: Print VBA code

2013-04-26 Thread Vijay Kr. Aggarwal
Hi Amar, Please check below code for your requirement. Public Sub cusPrintArea() Dim myRange As String myRange = Selection.Address ActiveSheet.PageSetup.PrintArea = myRange On Error Goto 1 1: Exit Sub With ActiveSheet.PageSetup .LeftHeader = "" .CenterH

Re: $$Excel-Macros$$ Re: Print VBA code

2013-04-21 Thread amar takale
Yes Abhishek ji,I want fixed range for print & when I want to change range after data expand then only changed range.That its only. Can you give me this code or sample attached file with code. On Mon, Apr 22, 2013 at 10:50 AM, Abhishek Jain wrote: > So you have a fixed area to be printed every t

Re: $$Excel-Macros$$ Re: Print VBA code

2013-04-21 Thread Abhishek Jain
So you have a fixed area to be printed every time ? Or you want to print the selected area ? On Mon, Apr 22, 2013 at 10:43 AM, amar takale wrote: > Dear Abhishek, > PFA Sheet here > > > On Mon, Apr 22, 2013 at 10:29 AM, Abhishek Jain wrote: > >> Share a sample file. >> >> >> On Mon, Apr 22, 20

Re: $$Excel-Macros$$ Re: Print VBA code

2013-04-21 Thread Abhishek Jain
Share a sample file. On Mon, Apr 22, 2013 at 10:23 AM, amar takale wrote: > Dear All,Can anyone help me on this topic. > > > On Fri, Apr 19, 2013 at 12:18 PM, amar takale wrote: > >> Dear Kavita >> Can you give me Proper full Code then I put it excel & run it only.Bcos I >> am VBA learner only.I

Re: $$Excel-Macros$$ Re: Print VBA code

2013-04-21 Thread amar takale
Dear All,Can anyone help me on this topic. On Fri, Apr 19, 2013 at 12:18 PM, amar takale wrote: > Dear Kavita > Can you give me Proper full Code then I put it excel & run it only.Bcos I > am VBA learner only.I am unfamiliar about VBA Coding. > Regards > Amar > > > On Fri, Apr 19, 2013 at 11:12

Re: $$Excel-Macros$$ Re: Print VBA code

2013-04-18 Thread amar takale
Dear Kavita Can you give me Proper full Code then I put it excel & run it only.Bcos I am VBA learner only.I am unfamiliar about VBA Coding. Regards Amar On Fri, Apr 19, 2013 at 11:12 AM, kavita ahuja wrote: > Hi Amar, > > You can use the below code to set print area and take print in excel sheet

$$Excel-Macros$$ Re: Print VBA code

2013-04-18 Thread kavita ahuja
Hi Amar, You can use the below code to set print area and take print in excel sheet Sheet1.PageSetup.PrintArea = "A1:D10" Sheet1.PrintOut Thanks Kavita On Thursday, April 18, 2013 7:58:54 PM UTC+5:30, amar takale wrote: > > Dear Experts team > Here I required Print command for select data.I crea

$$Excel-Macros$$ Re: Print VBA code

2013-04-18 Thread kavita ahuja
Hi Amar, You can use the below code to set print area and take print in excel sheet Sheet1.PageSetup.PrintArea = "A1:D10" Sheet1.PrintOut Thanks Kavita On Thursday, April 18, 2013 7:58:54 PM UTC+5:30, amar takale wrote: > > Dear Experts team > Here I required Print command for select data.I crea