Fwd: $$Excel-Macros$$ Re: Print settings to change at a time for multiple sheets

How to use it to change the print preview settings. -- Forwarded message -- From: Lalit Mohan Pandey Date: Tue, Apr 2, 2013 at 10:24 AM Subject: $$Excel-Macros$$ Re: Print settings to change at a time for multiple sheets To: excel-macros@googlegroups.com By using below event of

Re: $$Excel-Macros$$ VBA Code for delete Entire Row after Criteria Match

Dear Amar, firstly remove refrence . simple copy the entire cell and paste it as values . Step 1) select the entire coloum (D) then press cltr+F. write 0 and tick mark the option of mark entire cell content and press * FindAll* button. Step2) now, at down side u find all the finding references s

$$Excel-Macros$$ VBA Code for delete Entire Row after Criteria Match

Dear Friends Pls modified Code in my sheets.Only D column find 0 Value then entire Row delete. Regards Amar -- 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 Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM

Re: $$Excel-Macros$$ Print settings to change at a time for multiple sheets

if you are using excel 2010 then simply just group all worksheets then go-to Print option then change setting select "print active sheets" [image: Inline image 1] . Enjoy Team XLS On Mon, Apr 1, 2013 at 3:39 PM, Pravin Gunjal wrote: > Can we change the print settin

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

Hi Dhaval, dhaval shah (1).xlsx PFA... . Enjoy Team XLS On Tue, Apr 2, 2013 at 10:39 AM, Dhaval Shah wrote: > cmp is current market price ( CLOSE PRICE ) > > > On Tue, Apr 2, 2013 at

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

cmp is current market price ( CLOSE PRICE ) On Tue, Apr 2, 2013 at 10:18 AM, xlstime wrote: > what is CMP ?... > > you can use sumifs or sumproduct > > > > . > > Enjoy > Team XLS > > > > On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah wrote: > >> Hello all experts >> >> any

$$Excel-Macros$$ Re: Arrangement head of the table in the macro code

To change worksheet name you are doing right and except this what you want is not clear so if there is something for which you need help you need to specify it clearly. On Tuesday, 2 April 2013 00:30:06 UTC+5:30, artforart artforart wrote: > > I must change a head in the original table. > I have

Re: $$Excel-Macros$$ speedometer in excel

On Tue, Apr 2, 2013 at 12:28 AM, vijayajith VA wrote: > Hi , > > > > http://gautamg.wordpress.com/2013/03/30/creating-a-speedometer-in-excel/?goback=%2Egde_82527_member_227695807 > > > On Tue, Apr 2, 2013 at 12:27 AM, vijayajith VA wrote: > >> Hi, >> >> You can try below link/ >> >> http://www.bra

$$Excel-Macros$$ Re: Print settings to change at a time for multiple sheets

By using below event of workbook *Private Sub Workbook_BeforePrint(Cancel As Boolean)* *End Sub* you can specify the different print settings for different sheets On Monday, 1 April 2013 15:39:17 UTC+5:30, Pravin Gunjal wrote: > > Can we change the print settings at a time for multiple sheets, a

$$Excel-Macros$$ Re: Need expert advise for multipal Selection

Colud you please elaborate. On Tuesday, 2 April 2013 09:56:37 UTC+5:30, Dhaval Shah wrote: > > Hello all experts > > any solution for my query > > > On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah > > wrote: > >> Dear Experts >> >> I want to make out multipul selection for my project pls refer my

Re: $$Excel-Macros$$ Re: Need expert advise for multipal Selection

what is CMP ?... you can use sumifs or sumproduct . Enjoy Team XLS On Tue, Apr 2, 2013 at 9:56 AM, Dhaval Shah wrote: > Hello all experts > > any solution for my query > > > On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah wrote: > >> Dear Experts >> >> I want to make o

$$Excel-Macros$$ Re: Need expert advise for multipal Selection

Hello all experts any solution for my query On Mon, Apr 1, 2013 at 4:37 PM, Dhaval Shah wrote: > Dear Experts > > I want to make out multipul selection for my project pls refer my sheet > > > > Thanks > > Dhaval Shah > -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? I

$$Excel-Macros$$ Re: Find out 6 digit Number

Hi Satheesh you can use Len function to know if the abc is a 6 digit Number. For Example: *len(Cstr(abc))* Regards Prince On Monday, April 1, 2013 5:12:36 PM UTC+5:30, Satheeshkumar Yadav wrote: > > Hi VBA Expert, > > Quiz Questions? can anyone answer this through VBA functions? > > abc is s

Re: $$Excel-Macros$$ speedometer in excel

Hi , http://gautamg.wordpress.com/2013/03/30/creating-a-speedometer-in-excel/?goback=%2Egde_82527_member_227695807 On Tue, Apr 2, 2013 at 12:27 AM, vijayajith VA wrote: > Hi, > > You can try below link/ > > http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm > > >

Re: $$Excel-Macros$$ speedometer in excel

Hi, You can try below link/ http://www.brainbell.com/tutorials/ms-office/excel/Create_A_Speedometer_Chart.htm On Tue, Apr 2, 2013 at 12:22 AM, Midhun Thampan wrote: > hi anyone have an idea of how to use a sppeometer in excel. > kindly provide me some details and how to use in excel. > > > -- >

$$Excel-Macros$$ speedometer in excel

hi anyone have an idea of how to use a sppeometer in excel. kindly provide me some details and how to use in excel. -- Midhun Thampan. Administrator(Business Process Management) Maersk Global Services. Powai, Hiranandani. Mumbai:400076 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

Re: $$Excel-Macros$$ hi all***need code to attacha file in outlook and send it to respective email id***

Hi ashish, Thanks your very much, it solved my query. On Sat, Mar 30, 2013 at 10:03 AM, ashish koul wrote: > try the attachment .. see if it helps > > > > On Fri, Mar 29, 2013 at 10:37 PM, maksood alam <786maks...@gmail.com>wrote: > >> Hi all >> >> please send me the code to attach a file i

$$Excel-Macros$$ Find out 6 digit Number

Hi VBA Expert, Quiz Questions? can anyone answer this through VBA functions? abc is six digit number also below conditions bca = 3 * abc cab = 5 * abc what is abc nos?( it is a six digit number) -- Thanks & regards Satheeshkumar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do

$$Excel-Macros$$ Print settings to change at a time for multiple sheets

Can we change the print settings at a time for multiple sheets, as i have an unique data in each sheet. Please help. Regards Pravin Gunjal. -- 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 Facebook page of this forum @ https://www

Re: $$Excel-Macros$$ Pls help another approach.

Dear All, Any Progress.Pls ...Help. Warm Regards, Gawli Anil On Sat, Mar 30, 2013 at 2:58 PM, अनिल नारायण गवली wrote: > Dear Friends, > > From the attached sheets i want the smallest amt soldtocode lookup with > material code > > for eg:- now the material code is 16421126161 > > This mate

$$Excel-Macros$$ Re: saving function to use in all workbooks

Hi Drik, By creating addins of that function u can use that function in your all workbook. Regards Prince On Thursday, March 28, 2013 3:53:51 PM UTC+5:30, Dirk Lahaye wrote: > > > > Hi, > How can i use a self created function in all my workbooks ? > Thanks for your ideas > Dirk > -- Are you =

Re: $$Excel-Macros$$

Dear Rajan Thanks for reply Column E,F -: May be blank if there is value Character should not be greater than 60 Column G -: Should not be blank and Character should not be greater than 5 and takes only neumerical value. Dear XL time I have to create a sheet with all the condition mention

Re: $$Excel-Macros$$ Formula required help

Abhi, Thx for quick reply. Thanks again. Rgds, IQbal On 1 April 2013 12:29, Abhishek Jain wrote: > =IF(AND(D2>=C2,L2=1),"Winner","Looser") > > Drag down. > > > > On Mon, Apr 1, 2013 at 12:21 PM, Shaikh Iqbal wrote: > >> Dear Export , >> >> Please find attached file & help on formula. >>

Re: $$Excel-Macros$$ Formula required help

=IF(AND(D2>=C2,L2=1),"Winner","Looser") Drag down. On Mon, Apr 1, 2013 at 12:21 PM, Shaikh Iqbal wrote: > Dear Export , > > Please find attached file & help on formula. > > > > > > > > > Iqbal > > -- > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s > =TIME(2,DO:IT,N