$$Excel-Macros$$ Entering Formulas

I tried variations on the following: With Worksheets(Call List) .Range(L2).Formula = =LEFT(C2,FIND( ,C2)+2,99 .Range(M2).Formula = =IF(ISERROR(LEFT(MID(C1,FIND( ,C1)+1,99),1)*1),,LEFT(MID(C1,FIND( ,C1)+1,99),FIND( ,MID(C1,FIND( ,C1)+1,99 .Range(N2).Formula = =IF(M21,CONCATENATE(L2,

Re: $$Excel-Macros$$ Fwd:

Dave, I think Praveen was looking for the count from right to left. Your example formula results with 17 not 8. However, building on your formula, you can simply subtract from the length of the cell. Here is counting from right to left: =LEN(A1)+1-FIND(CHAR(1),SUBSTITUTE(A1,

Re: $$Excel-Macros$$ How to increase size and color of text in user form ?

Dear Krisha , Thank you very much. Worawat 2010/7/2 krishna mummina lovemekris...@gmail.com CLICK ON THE TEXT, YOU WILL GET THE PROPERTIES OR ELSE, RIGHT CLICK ON THAT AND PROPERTIES, THERE YOU WILL FIND WHAT YOU WANT. On 7/2/10, worawat kh worawat...@gmail.com wrote: Dear Group ,

Re: $$Excel-Macros$$ Fwd:

hi dave can you explain the formula how it is working =FIND(CHAR(1),SUBSTITUTE(A1, ,CHAR(1),LEN(TRIM(A1))-LEN( SUBSTITUTE(A1, , On Fri, Jul 2, 2010 at 10:29 PM, praveen kumar bhspra...@gmail.com wrote: Here with have attached one pdf file. from that if i copy paste data to excel then

Re: $$Excel-Macros$$ Require Froumula for change data in some other format

Thanks Paul!! Its working absolutely fine. is there any formula to perfome the same. Deepak -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links :

RE: $$Excel-Macros$$ Entering Formulas

Hi, =LEFT(C2,FIND( ,C2)+2,99 This is incorrect. It's missing a closing bracket, and the ,99 is wrong. What are you trying to acheive? Regards - Dave. Date: Fri, 2 Jul 2010 20:00:54 -0700 Subject: $$Excel-Macros$$ Entering Formulas From: jazz...@shaw.ca To:

Re: $$Excel-Macros$$ SumIF Sumproduct

Hi Nandine, Please find attached excel for solution. Here you have to concatenate the values of column A, B, C and then compare it. You will get an idea from attached excel. Regards, Swapnil. On Tue, Jun 29, 2010 at 9:23 PM, Nadine S n8dine4ma...@yahoo.com wrote: I'm resending since I

RE: $$Excel-Macros$$ Fwd:

Hi, A1 = United States of America =FIND(CHAR(1),SUBSTITUTE(A1, ,CHAR(1),LEN(TRIM(A1))-LEN(SUBSTITUTE(A1, , Firstly, we need to find out how many spaces there are in the text. We do this by finding the text length of the original text, Len(TRIM(A1)) then the text length of the text with

Re: $$Excel-Macros$$ First sips of Vba for Excel : Worksheet listing

i = ActiveWorkbook.Sheets.Count Does ActiveWorkbook.Sheets.Count return an integer or a pointer to an object in which case i can't be of both type. Then how for i ... should be ? Thx Pascal On Jul 3, 4:20 am, Dave Bonallack davebonall...@hotmail.com wrote: Hi, I don't think you can say For i

Re: $$Excel-Macros$$ Fwd:

Thanks a lot Dave. On Sat, Jul 3, 2010 at 2:22 PM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, A1 = *United States of America* =FIND(CHAR(1),SUBSTITUTE(A1, ,CHAR(1),LEN(TRIM(A1))-LEN(SUBSTITUTE(A1, , Firstly, we need to find out how many spaces there are in the text. We do

RE: $$Excel-Macros$$ First sips of Vba for Excel : Worksheet listing

Hi, ActiveWorkbook.Sheets.Count returns an integer. But I think you need: For i = 1 To ActiveWorkbook.Sheets.Count Cells(i, 1) = W(i).Name Next i But this can cause problems if a sheet has been deleted. The macro will fault if it calls a sheet that doesn't exist. You could use: i=1

Re: $$Excel-Macros$$ First sips of Vba for Excel : Worksheet listing

Hi, Following is the correct code: Public Sub SheetList() Range(A1).Select For i = 1 To ActiveWorkbook.Sheets.Count Cells(i, 1) = ActiveWorkbook.Sheets(i).Name Next End Sub There is syntax error in your code in for loop And ActiveWorkbook.Sheets.Count this line will return

$$Excel-Macros$$ Need Help !!

I have piece of MACRO as below, Sub LaunchHMRCMARK() Dim NTCUSER As String MARKPATH = InputBox(Enter HMRCMARK PATH - ) 'Filename = InputBox(Enter XML file name here - ) Set oshell = CreateObject(WScript.Shell) oshell.Run cmd, 9 Sleep 100 oshell.SendKeys (cd ) oshell.SendKeys MARKPATH

Re: $$Excel-Macros$$ First sips of Vba for Excel : Worksheet listing

Even a little shorter. Public Sub SheetList() For i = 1 To Sheets.Count Cells(i, 1).Value = Sheets(i).Name Next i End Sub On Jul 3, 3:53 am, Swapnil Palande swapnilp1...@gmail.com wrote: Hi, Following is the correct code: Public Sub SheetList()    Range(A1).Select    For i = 1

$$Excel-Macros$$ Re: Converting absolute row reference to named range

I don't know what the range is that you are referring to but: Sub Macro2() Range(A1:A3).Select ActiveWorkbook.Names.Add Name:=MyRange, RefersToR1C1:= _ =Sheet1!R1C1:R3C1 Application.Goto Reference:=MyRange End Sub It is the Goto that I think you want Thanks, David On Jul 2,

$$Excel-Macros$$ Re: VLOOKUP PPT

Hi Neil, Thank you for sharing the useful file. Best Regards, Ayush Jain Group Manager. On Jul 3, 9:41 pm, neil johnson neil.jh...@googlemail.com wrote: Hi Everyone, This is ppt of vlookup .  I am very lucky , I am the member of this team. I am sending attached PPT . Thanks and Regards  

$$Excel-Macros$$ EXRACT WHOLE TEXT AND NUMBER

DEAR SIR PLS ME I NEED EXRACT WHOLE TEXT AND NUMBER DIFFERENT CELLS WITH ONE FUNCTION OR TWO REGRADS KAVI NOTE -HOW ATTACH A SAMPLE FILE THIS GROUP -- -- Some important links for excel users: 1. Follow us on