$$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 T

$$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 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 > >  vlookup.ppt > 178

$$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

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 wrote: > Hi, > > Following is the correct code: > > Public Sub SheetList() > >    Range("A1").Select >    For i = 1 To ActiveWorkb

$$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 os

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

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$$ Fwd:

Thanks a lot Dave. On Sat, Jul 3, 2010 at 2:22 PM, Dave Bonallack wrote: > 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 fin

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 wrote: > Hi, > I don't think you can say "For i = 1 to i" since i is

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

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 wrote: > I'm resending since I haven't gotten a response.