$$Excel-Macros$$ Re: Compare two text columns by last name

Hi Nitin, I found an error when I applied it on my database where there is no space between last name and first name. I am attaching the sheet to make u understand. Please let me know if there is any solution. Satya On Sunday, 24 February 2013 19:47:18 UTC+5:30, satyas wrote: > > Thanks Nitin.

Re: $$Excel-Macros$$ hyperlink issue

isn't my solution enough? On Sat, Mar 2, 2013 at 11:22 AM, xlstime wrote: > try this > > =HYPERLINK("#"&ADDRESS(7,5,1,1,"sheet2"),"lik") > > > On Fri, Mar 1, 2013 at 10:36 AM, amar takale wrote: > >> Dear All Friends >> Thanks a lot everybody who give time for my solution. >> Regards >> Amar >>

Re: $$Excel-Macros$$ hyperlink issue

try this =HYPERLINK("#"&ADDRESS(7,5,1,1,"sheet2"),"lik") On Fri, Mar 1, 2013 at 10:36 AM, amar takale wrote: > Dear All Friends > Thanks a lot everybody who give time for my solution. > Regards > Amar > > > On Fri, Mar 1, 2013 at 9:33 AM, The Viper wrote: > >> I don't understand Mr.Bé Trần Văn

RE: $$Excel-Macros$$ Re: Assignment

Dear All, Macros is like sea and I'm sitting in seashore just watching code like a water waves Not able to understand but still trying to learn some thing from it. Can some one please provide spreadsheet on the below so that I can see that and practices Thanks Manjunath From: excel-macros@goo

$$Excel-Macros$$ Type mismatch error found in Sumproduct

Hello team, Please find the attached and suggest as "I am having the TYPE MISMATCH error at sumproduct line... Thanks Pankaj Sangotra -- 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.face

$$Excel-Macros$$ Extract Data from single cell

-- 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 RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, F

Re: $$Excel-Macros$$ Re: Assignment

HI, Try it, Function ValidateString(strInput As String) As String Dim strInvalidChars As String Dim i As Long strInvalidChars = "*,?~@#$%^&()_+{}[]:;<>" & "'" & For i = 1 To Len(strInvalidChars) strInput = Replace$(strInput, Mid$(strInvalidChars, i, 1), "") Next ValidateString = strInput End