$$Excel-Macros$$ help:increase the sheet number in a formula

Hi Gurus, Please help me in this formula increase the sheet number in formula =IF(IF(ISNUMBER(SEARCH(C$2,*Sheet1*!$B1)),"TRUE",0)="TRUE",TRIM(RIGHT(* Sheet1*!$B1,LEN(*Sheet1*!$B1)-FIND(":",SUBSTITUTE(*Sheet1*!$B1," ",":",LEN(* Sheet1*!$B1)-LEN(SUBSTITUTE(*Sheet1*!$B1," ","")),0) I would lik

RE: $$Excel-Macros$$ VBA enabled sheet doesn't allow to protect

Sub DoSomething() Sheet1.Unprotect Pwd 'Your code goes here Sheet1.Protect Pwd End sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Pravin

Re: $$Excel-Macros$$

Thanks to all Just one question for Knowledge I run the script by both way 1.By Making true at the end 2.Without making true at end I could not notice any difference. So please can any one explain me What is the purpose of making true at end? Aging I ma repeating this is just for Knowledge. Regard

RE: $$Excel-Macros$$ Excel 2007 - VBA - Chart format

Try this ActiveChart.ChartArea.Format.Fill.GradientStops.Insert(RGB) Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Daniel Sent: 20 October 2012 12:57 To: excel-macros@googlegroups.com Subject:

$$Excel-Macros$$ Excel 2007 - VBA - Chart format

Hello, all, Someone asks me if it were possible to format a chart area with a gradient fill of more than two colors. I can't find no clue to this one. Can anyone help ? TIA Daniel -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ m

$$Excel-Macros$$ Need your advise - MS Access 2007 drop down list Macro

Hi Friends, I am using MS Access 2007. I have table called "City". The table "City" contains the information of the different cities of INDIA with their details. For example, CityDetails Mumbai It is the Financial capital of India Delhi Capital of India I have also form for r

Re: $$Excel-Macros$$ Pls help with a lookup formula to pick up ratings. *

THANKS BOSS On Fri, Oct 19, 2012 at 5:20 PM, Swapnil Palande < palande.swapni...@gmail.com> wrote: > [image: Boxbe] This message is eligible > for Automatic Cleanup! (palande.swapni...@gmail.com) Add cleanup > rule

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

Yes, but in the combobox "Save as type:" I don't have PDF format. Best regards, *Constantin ZAMFIR* Service engineer, Euritmic Grup SRL - Romania Mobil: +40 741-105-012 (Orange) Mobil: +40 726-226-021 (Cosmote) *Before printing this e-mail please consider environmen

Re: $$Excel-Macros$$ Please help me to set default folder for print PDF's.

Hi, Insted of printing with the help of Nitro PDF you can save file as PDF. Rgds//Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: Constantin Zamfir Sender: excel-macros@googlegroups.com Date: Fri, 19 Oct 2012 10:35:38 To: Reply-To: excel-macros@googlegroups.com Sub

$$Excel-Macros$$ Please help me to set default folder for print PDF's.

I have a macro in an Excel document that print 5 sheets in different folders with different names. Always have to navigate to the desired folder and write the desired name, which slows my work, since I'm doing this for 30-50 times per day. I want to automate this in my macro, but I do not know

Re: $$Excel-Macros$$ Pls help with a lookup formula to pick up ratings.

Hi, Try below formula. =IF(AND(A1<=-0.5,A1>=-1),"STRONG BUY",IF(AND(A1<=-0.2,A1>=-0.49),"BUY",IF(AND(A1<=0.19,A1>=-0.19),"HOLD",IF(AND(A1<=0.49,A1>=0.2),"STRONG SELL",IF(AND(A1<=1,A1>=0.5),"SELL",FALSE) Regards, Swapnik. On Oct 19, 2012 10:08 PM, "Hilary Lomotey" wrote: > Hello Experts >

$$Excel-Macros$$ Pls help with a lookup formula to pick up ratings.

Hello Experts i need a formula such that if my results falls between the categories listed below, i get the ratings eg if my result in cell A1 is -25.3% then i shd get a rating of BUY, If cell A1 is say 2% then i shd get a HOLD rating. -50% -100% STRONG BUY -20% -49% BUY -19% 19% HOLD 50% 1

Re: $$Excel-Macros$$ request to separate the no

hi ashsih koul, it is working very thanks , regards, shivaprasad. On Fri, Oct 19, 2012 at 9:16 PM, ashish koul wrote: > check the attachment see if it helps > > > On Fri, Oct 19, 2012 at 9:10 PM, Shiva Prasad > wrote: > >> hi ashish koul, >> >> please find the attachment of example. >> >

Re: $$Excel-Macros$$ request to separate the no

check the attachment see if it helps On Fri, Oct 19, 2012 at 9:10 PM, Shiva Prasad wrote: > hi ashish koul, > > please find the attachment of example. > > i mentioned formula also but showing 0 value. > please provide the macro. > > > regards, > shivaprasad. > > On Fri, Oct 19, 2012 at 9:02 PM,

Re: $$Excel-Macros$$ request to separate the no

hi ashish koul, please find the attachment of example. i mentioned formula also but showing 0 value. please provide the macro. regards, shivaprasad. On Fri, Oct 19, 2012 at 9:02 PM, ashish koul wrote: > can u share any excel file with input and output u like to have > > > On Fri, Oct 19, 20

Re: $$Excel-Macros$$ request to separate the no

can u share any excel file with input and output u like to have On Fri, Oct 19, 2012 at 9:01 PM, Shiva Prasad wrote: > hi ashish koul, > > please provide the example attachment. > > > regards, > shivaprasad. > > > On Fri, Oct 19, 2012 at 8:55 PM, ashish koul wrote: > >> try this udf >> >> Funct

Re: $$Excel-Macros$$ request to separate the no

hi ashish koul, please provide the example attachment. regards, shivaprasad. On Fri, Oct 19, 2012 at 8:55 PM, ashish koul wrote: > try this udf > > Function numeric_value(x As String) > Dim a As String > a = "" > For i = 1 To Len(x) > If IsNumeric(Mid(x, i, 1)) Then > a = a & Mid(x, i, 1) >

Re: $$Excel-Macros$$ request to separate the no

try this udf Function numeric_value(x As String) Dim a As String a = "" For i = 1 To Len(x) If IsNumeric(Mid(x, i, 1)) Then a = a & Mid(x, i, 1) End If Next i numeric_value = a End Function On Fri, Oct 19, 2012 at 8:35 PM, Shiva Prasad wrote: > hi experts, > > how to separate the number, > i m

$$Excel-Macros$$ request to separate the no

hi experts, how to separate the number, i mentioned in excel cell please help me *example asdfhfgh9825101236sdfge, 9855255689dffhjrr * i want only number, can any one provide the macro. regards, shivaprasad. -- Regards, Shivaprasad K. +91-9866351016 -- Join official facebook page of

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting) *

This might help http://www.excelfox.com/forum/f13/extract-number-alphanumeric-text-186/ Regards, Sam On Fri, Oct 19, 2012 at 8:24 PM, Shiva Prasad wrote: > hi experts, > > how to separate the number, > i mentioned in excel cell > mentioned example > > > *example > > asdfhfgh9825101236sdfge, > 9

Re: $$Excel-Macros$$ Google Map and Excel Integration Using VBA

This is very good Ashish. Thanks for sharing. Regards, Sam On Fri, Oct 19, 2012 at 7:20 PM, ashish koul wrote: > Hi All, > > If you want to get latitude and longitude of any address or you want to > find the distance between two cities , etc using Google Map. Please find > below links of macr

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting) *

hi i tried ur file its working fine at my place. Can you share the actual file and output in word document On Fri, Oct 19, 2012 at 4:54 PM, amar takale wrote: > Pls help me on below topic > > > On Thu, Oct 18, 2012 at 6:31 PM, amar takale wrote: > >> Dear Hilary >> Your code not working it sh

RE: $$Excel-Macros$$

But also make them TRUE at end of code Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shrinivas Shevde Sent: 19 October 2012 5:25 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

Re: $$Excel-Macros$$

Hi Also dont forget to put a the end.. application.displayalerts = true Application.screenupdating= true Else user will wonder whats going wrong.. Rgds//Vabs On Friday, October 19, 2012 5:25:18 PM UTC+5:30, shrini wrote: > > Dear Both, > > Very very thanks for solution. > > Regards > Shri

$$Excel-Macros$$ Re: Pls Help Me on this

Brother send a sample sheet. On Fri, Oct 19, 2012 at 3:30 PM, अनिल नारायण गवली wrote: > suppose there is one two excel file > one is A > second is B > in A file there is 2 fields like (Shiptocode) and (Productcode). > in B file there is 5 fields like (Shiptocode) and (Productcode)and(Type) > Typ

Re: $$Excel-Macros$$

Dear Both, Very very thanks for solution. Regards Shrinivas On Fri, Oct 19, 2012 at 1:19 PM, wrote: > ** > Hi > > Just put Application.Screenupdating = False > > Rgds// Vabs > > Sent on my BlackBerry® from Vodafone > -- > *From: *Shrinivas Shevde > *Sender: *excel-

Re: $$Excel-Macros$$ Re: Excel table Copy Paste in word (with formatting) *

Pls help me on below topic On Thu, Oct 18, 2012 at 6:31 PM, amar takale wrote: > Dear Hilary > Your code not working it show out of range I will attached file as per you > suggest link below It also not working Pl see file > > > On Wed, Oct 17, 2012 at 10:33 PM, Hilary Lomotey wrote: > >> try th

Re: $$Excel-Macros$$ Pls Help Me on this

Anil, if possible pls share a sample sheet with group. On Fri, Oct 19, 2012 at 3:30 PM, अनिल नारायण गवली wrote: > suppose there is one two excel file > one is A > second is B > in A file there is 2 fields like (Shiptocode) and (Productcode). > in B file there is 5 fields like (Shiptocode) and (Pr

$$Excel-Macros$$ Pls Help Me on this

suppose there is one two excel file one is A second is B in A file there is 2 fields like (Shiptocode) and (Productcode). in B file there is 5 fields like (Shiptocode) and (Productcode)and(Type) Type field is only two value (TRUE or FALSE) and (DP) and (RSP). i have inserted and new field in A file

$$Excel-Macros$$ How to crack the VBA password

*Dear Friend,* * * *Can you update on this please.* * * *Regards* *Pravin Gunjal* * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like P

Re: $$Excel-Macros$$

Hi Just put Application.Screenupdating = False Rgds// Vabs Sent on my BlackBerry® from Vodafone -Original Message- From: Shrinivas Shevde Sender: excel-macros@googlegroups.com Date: Fri, 19 Oct 2012 12:29:55 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dear

Re: $$Excel-Macros$$ need formula

Hi Rajesh, Try this one. For Max: =MAX(IF(ISERROR(A2:A40),0,A2:A40)) For Min: =MIN(IF(ISERROR(A2:A40),40,A2:A40)) With Ctrl+Shift+Enter. Regards, Kuldeep Singh On Fri, Oct 19, 2012 at 1:05 PM, NOORAIN ANSARI wrote: > Dear Rajesh, > > Please try it.. > =MAX(IF(ISERROR(A2:A40),0,A2:A40)) > > =M

Re: $$Excel-Macros$$ need formula

Dear Rajesh, Please try it.. =MAX(IF(ISERROR(A2:A40),0,A2:A40)) =MIN(IF(ISERROR(A2:A40),0,A2:A40)) On Fri, Oct 19, 2012 at 12:54 PM, Rajesh Agarwal wrote: > Dear Sir > I need formula in b2 and c2 max and minimum value of a2:a40 excluding > other than numbers. > rgds > > -- > *Rajesh Kumar Aga

Re: $$Excel-Macros$$ need formula

Following formulas for Max & Min with C+S+E =MAX(IF(ISNUMBER(A2:A40),A2:A40)) =MIN(IF(ISNUMBER(A2:A40),A2:A40)) Regards, Aamir Shahzad On Fri, Oct 19, 2012 at 12:24 PM, Rajesh Agarwal wrote: > Dear Sir > I need formula in b2 and c2 max and minimum value of a2:a40 excluding > other than numbe

$$Excel-Macros$$ need formula

Dear Sir I need formula in b2 and c2 max and minimum value of a2:a40 excluding other than numbers. rgds -- *Rajesh Kumar Agarwal* *9811063001* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use

Re: $$Excel-Macros$$

Use application.displayalerts = false Application.screenupdating= false At the beginning of code And turn them true at the end of code before end sub Sent on my BlackBerry® from Vodafone -Original Message- From: Shrinivas Shevde Sender: excel-macros@googlegroups.com Date: Fri, 19 O