Re: $$Excel-Macros$$ macro vba coding for html file search and paste the path as hyperlink

Hi , See below link.. http://www.pcreview.co.uk/forums/re-search-html-access-vba-t3992723.html *Best Regards,* *Venkat * *Chennai* * * On Thu, Mar 22, 2012 at 12:13 AM, Raj Mahapatra wrote: > hi all > > i am looking for some vba codes which will search html files (bases file > names in the sh

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Dear Noorain, Superb *Best Regards,* *Venkat * *Chennai* 2012/3/23 NOORAIN ANSARI > जहाँ Excel के दीवानों की, है बहूत घनी आबादी. > जहाँ Question,Answer करने की,है खूब आज़ादी. > जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया. > दोस्तों उस अपने Excel-Macro ग

Re: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

superb noorain bhai. 2012/3/22 NOORAIN ANSARI > जहाँ Excel के दीवानों की, है बहूत घनी आबादी. > जहाँ Question,Answer करने की,है खूब आज़ादी. > जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया. > दोस्तों उस अपने Excel-Macro ग्रुप का उम्र, अब 5 साल हो गया. > चाहे

Re: $$Excel-Macros$$ Simple VBA to Fill in blanks

Dear Jim, Please try it.. Sub Fill_Blanks() Cells.SpecialCells(xlBlanks).Delete End Sub -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Fri, Mar 23, 2012 at 7:04 AM, Jim Schug wrote: > Hi, > I

RE: $$Excel-Macros$$ Re: Arry Formula help

I think the main issue was the very large lookup ranges for that formula and other formulas, but you are right that a built-in function solution would probably be faster. I did not analyze what the VBA function was doing, but another powerful lookup function is DGET. It needs a separate criter

RE: $$Excel-Macros$$ Arry Formula help

Hi Avinash, The problem is that you are use massive ranges -- entire columns, which is many millions of cells. I see you already have a definied name (rptList) that is a dynamic range for the data on your "txt List" sheet. You could just using that named range in your formulas would pretty mu

$$Excel-Macros$$ Simple VBA to Fill in blanks

Hi, I'm nearly brain dead (tired) and can't think straight. I have a simple issue. A macro to fill in blank values if found with the value from the cell above. For example 101 1015 Would fill the blank rows with 101 until the next number 1015 is found, then it would use 1015 until an

RE: $$Excel-Macros$$ Re: Help to find position of a particular number in a given data set

Hi Atul, Not as tidy as Haseeb's response, But here is one solution: In C2: =IF(ROW(C$2)=ROW(),LARGE($B$2:$B$11,1),LARGE($B$2:$B$11,ROWS($B$2:$B$11)-COU NTIF($B$2:$B$11,"<"&INDEX(C$2:C$11,ROW()-2))+1)) In D2: =MATCH($B2,$C$2:$C$11,-1) Highlight and copy down. Your ranking is in column

RE: $$Excel-Macros$$ words split from a cell - with formulas only Not for VBA code

Hi again; I saw you asked for a non-VBA solution in your subject and assumed none had been posted yet, but I see that three such solutions were already posted. Here they are reiterated for your reference: Complements of Maries: =MID(A2,FIND(" ",A2,1)+1,LEN(A2)-MATCH(" ",LEFT(RIGHT(A2,{1,2,3,4,

RE: $$Excel-Macros$$ words split from a cell - with formulas only Not for VBA code

Hello Simha/NRao, All but the first and last words: =MID(TRIM($A2),FIND(" ",TRIM($A2))+1,FIND(CHAR(1),SUBSTITUTE(TRIM($A2)," ",CHAR(1),LEN(TRIM($A2))-LEN(SUBSTITUTE($A2," ",""-FIND(" ",TRIM($A2))-1) The formula ignores leading and trailing spaces, and also won't return leading and trai

Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

Thanks @ dguillett1. On Thu, Mar 22, 2012 at 6:36 PM, dguillett1 wrote: > Private Sub Worksheet_Change(ByVal Target As Range) > If Target.Count > 1 _ > Or Target.Row < 2 Then Exit Sub > If Target.Column = 1 Or Target.Column = 3 Then > If Len(Application.Trim(Target)) > 0 Then _ > Target.O

RE: $$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

Beautiful :) I hardly understand it, but I hear the poetry in it when read by Google Translate's screen reader, and in the rough translation. Thank YOU Noorain for all you do here, and for being our Poet in Residence; our poet laureate. From: excel-macros@googlegroups.com [mailto:excel-

RE: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

I'm happy to see the success of your group, Ayush. I found it I believe simply by searching Google Groups to see what the largest groups were. You do an excellent job of keeping the forum virtually free of spam. If anything, just these two things would make your exlllent forum even better - a

Re: $$Excel-Macros$$ Excel formula help needed

genius Maries Great solution. works to perfection. thanks boss On Thu, Mar 22, 2012 at 3:56 PM, Maries wrote: > HI, > > Please find the attached file of Revised one. Ignore Previous one. > > Regards, > > MARIES. > > > On Thu, Mar 22, 2012 at 7:07 PM, Maries wrote: > >> Hi, >> >> PFA. >> >> =I

$$Excel-Macros$$ कविता: अपने Excel-Macro ग्रुप का उम्र,अब 5 साल हो गया.****** FIVE YEARS COMPLETION******THANK YOU******

जहाँ Excel के दीवानों की, है बहूत घनी आबादी. जहाँ Question,Answer करने की,है खूब आज़ादी. जहाँ के पोस्ट को follow कर-कर के,कितनो का Career खुशहाल हो गया. दोस्तों उस अपने Excel-Macro ग्रुप का उम्र, अब 5 साल हो गया. चाहे सुबह हो या शाम, चाहे दिन हो या रात. हर समय होती है यहाँ पोस्टि

RE: $$Excel-Macros$$ Split text in cell

=MID(A2,FIND(" ",A2,1)+1,MAX(--(MID(A2,ROW(INDIRECT("1:"&LEN(A2))),1)=" ")*ROW(INDIRECT("1:"&LEN(A2-FIND(" ",A2,1)) with CSE From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ms-Exl-Learner . Sent: Mar/Thu/2012 11:13 To: excel-macros@googlegroups.

$$Excel-Macros$$ Re: words split from a cell - with formulas only Not for VBA code

This is a duplicate thread. There are couple of replies to your last thread. Check out that please. ___ HTH, Haseeb On Thursday, March 22, 2012 8:22:08 AM UTC+3, nike wrote: > > Please find the attachment of my criteria. > > > Please refer column "A" and i want result in Column "'B" wh

$$Excel-Macros$$ Insert rows with missing data

I have data like so: Country Year AgeGroup Time Count A 05 10-6mo 10 A 05 16-12mo5 - B 05 10-6mo 12 B 05 112-18mo 4 B 05 118-24mo 75 (I added the "-" divid

$$Excel-Macros$$ Re: Split text in cell

Hello, try also, =TRIM(SUBSTITUTE(MID(A2,FIND(" ",TRIM(A2)&" "),LEN(A2)),TRIM(RIGHT(SUBSTITUTE(TRIM(A2)," ",REPT(" ",99)),99)),"")) On Wednesday, March 21, 2012 12:00:09 PM UTC+3, nike wrote: > > Hi Team, > > How to remove a words left text and right text of reference > > > Please refer attachm

Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

Congratulation Dear Ayush and all group members On Thu, Mar 22, 2012 at 4:25 AM, Ayush Jain wrote: > Dear members,** > > > > I am proud to announce that the forum has completed 5 years today. This is > really great milestone of the forum. > > My sincere thanks to each one of you w

$$Excel-Macros$$ Re: Asa R. I tried what you said for the column addressing but I can not make it work. Can you assist?

First before I forget, thanks again for the help. Maybe I need to go find a more comprehensive book. The one I have does not mention the Set command, does not list Range as a data type, does not mention tables (which may be useful but that is too ambitious at this point). >From the other thr

$$Excel-Macros$$ Re: Help to find position of a particular number in a given data set

Hello Atul, try this Assume B2:B11 is %, in C2 then copy down. =SUMPRODUCT((ISNUMBER(MATCH(ROW(INDEX(A:A,1):INDEX(A:A,RANK(B2,B$2:B$11))),INDEX(RANK(B$2:B$11,B$2:B$11),0),0))+0)) ___ HTH, Haseeb On Wednesday, March 21, 2012 12:24:21 AM UTC+3, Atul wrote: > > > Hi, > > I need help

Re: $$Excel-Macros$$ Split text in cell

Another Approach Copy and paste the below formula in 2nd Row of any cell other than A2 cell and drag it below. =IF((LEN(TRIM(A2))-LEN(SUBSTITUTE(TRIM(A2)," ","")))>1, TRIM(MID(TRIM(A2), FIND(" ",TRIM(A2))+1, (FIND("^",SUBSTITUTE(TRIM(A2)," ","^",(LEN(TRIM(A2))-LEN(SUBSTITU

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

Hi, I checked the VBAVlookup custom function, it is looking up using usernumber and the layout on the Txtlist sheet. If this is slowing down the performance of the application, I would recommend creating a column which concatenates the usernumber and layout column on the "txt list" sheet and o

Re: $$Excel-Macros$$ email extraction from gmail

thanks noorain and jitendra. On Thu, Mar 22, 2012 at 12:03 PM, Jitendra singh wrote: > give email id A1 box in sheet and run macro > > > --- > > Sub Mail

Re: $$Excel-Macros$$ creating hyperlink on userform

Assuming that you have placed full path of your file in the caption of your label (label1 in this case) itself... *Private Sub Label1_Click()* *Application.ThisWorkbook.FollowHyperlink Label1.Caption* *End Sub* ...should work. HTH On Thu, Mar 22, 2012 at 4:17 PM, Shankar Bheema wrote: > Dear

Re: $$Excel-Macros$$ ****** FIVE YEARS COMPLETION******THANK YOU******

Hey Ayush, excellent achievement. Sorry I am not being able to post frequently. My son's keeping us busy. But my congrats to ALL the great members of this forum, and hope there's more milestones met and achievements garnered in the future also Regards, Sam Mathai Chacko On Thu, Mar 22, 2012 at 1

Re: $$Excel-Macros$$ Re: Excel conditional formatting-Urgent plz

Thank you Meeran :) On Thu, Mar 22, 2012 at 8:39 PM, Damimkader S. Meeran wrote: > Hi, > > Please review the below link it is very helpful with simple examples. > > > http://www.free-training-tutorial.com/animations/conditional-formatting-examples.html > > > Regards, > Damimkader S. Meeran > > On

Re: $$Excel-Macros$$ Excel conditional formatting-Urgent plz

Hey Ansari, Don Ah!! very quick reply. Thank you very much , this helps. have a nice day. On Thu, Mar 22, 2012 at 8:32 PM, NOORAIN ANSARI wrote: > Dear vinod, > > See attached sheet, hope it help you. > > -- > Thanks & regards, > Noorain Ansari > *http://noorainansari.com/* > *http://excelmacro

$$Excel-Macros$$ Re: Excel conditional formatting-Urgent plz

Hi, Please review the below link it is very helpful with simple examples. http://www.free-training-tutorial.com/animations/conditional-formatting-examples.html Regards, Damimkader S. Meeran On Thursday, March 22, 2012 8:05:32 PM UTC+5:30, vnrao wrote: > > > Hello Experts, > > I need a con

Re: $$Excel-Macros$$ Excel conditional formatting-Urgent plz

Dear vinod, See attached sheet, hope it help you. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Thu, Mar 22, 2012 at 8:05 PM, vinod rao wrote: > > Hello Experts, > > I need a conditional cell co

Re: $$Excel-Macros$$ Excel conditional formatting-Urgent plz

And what if both? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: vinod rao Sent: Thursday, March 22, 2012 9:35 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Excel conditional formatting-Urgent plz Hello Experts, I need a conditional cell color

$$Excel-Macros$$ Excel conditional formatting-Urgent plz

Hello Experts, I need a conditional cell color showing where Region 1 showing the value over 10 should colour red and Region 2 value showing over 12 should show green. Attached file for the same. Region Value in $ 1 20 2 22 1 11 2 11 2 5 2 15 2 3 1 29 Regards, Vin -- FORUM RULES (986+ members

$$Excel-Macros$$ Re: Help to find position of a particular number in a given data set

My apology! I am overseas. Just email reply will be ok How ever if you want to dicuss on this I can call you too Pl provide your contact. Sent from my iPhone On 2012-03-22, at 9:27, Anand Kumar wrote: > with an improper contact number you expect me to reach you??? > > On Thu, Mar 22, 2012 at

Re: $$Excel-Macros$$ Excel formula help needed

HI, PFA. Regards, MARIES. On Thu, Mar 22, 2012 at 4:40 PM, hilary lomotey wrote: > Hi Oxford Excel Gurus > > In the fill attached sheet "P&L" i have been able to write a formula that > can show how many number of years i want to view the report ie if i want to > see 5 years report i will sele

$$Excel-Macros$$ Re: Help to find position of a particular number in a given data set

Hi Anand, Thank you for your response.Please refer to the calculation below. For repetitive items,rank formula removes subsequent rank for example 11 % rank 3 is not assigned due to multiple entry for the same standing. I want to ignore repetitive occurrences of rates and decide first, Second th

Re: $$Excel-Macros$$ Split text in cell

Macro looks for 1st space and last space and gets what is between. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: L.K. Modi Sent: Wednesday, March 21, 2012 11:23 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Split text in cell Dear All, Its

Re: $$Excel-Macros$$ Need a small help, related to the Date and Time macro.....

Private Sub Worksheet_Change(ByVal Target As Range) If Target.Count > 1 _ Or Target.Row < 2 Then Exit Sub If Target.Column = 1 Or Target.Column = 3 Then If Len(Application.Trim(Target)) > 0 Then _ Target.Offset(, 1) = Now End If End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...

Re: $$Excel-Macros$$ words split from a cell - with formulas only Not for VBA code

I already posted a reply Option Explicit Sub getmiddleSAS() Dim c As Range Dim fs As Long Dim ls As Long For Each c In Range("a2:a10") c = Application.Trim(c) fs = InStr(c, " ") ls = InStrRev(c, " ") c.Offset(, 1) = Mid(c, fs, ls - fs) Next c Columns("b").AutoFit End Sub Don Guillett Microsoft MV

Re: $$Excel-Macros$$ Compress of images

In the absence of a better explanation you might try sitting on them Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Veeru TOC Sent: Thursday, March 22, 2012 12:15 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Compress of images Dear Group

Re: $$Excel-Macros$$ Re: collision of data

Dear Shankar, Attachment missing. On Thu, Mar 22, 2012 at 4:24 PM, Shankar Bheema wrote: > > > On Thu, Mar 22, 2012 at 4:23 PM, Shankar Bheema wrote: > >> Dear Experts >> >> I attached an excel workbook. I made my office related form design on >> sheet1 of the work book. If the similar form of

Re: $$Excel-Macros$$ Re: Match text to a list

That's not true. MATCH("A",L6:L27,0) is not equal to MATCH("AA",L6:L27,0). Can you attach the workbook ? Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Pro

Re: $$Excel-Macros$$ Re: Macro for Insert a line for missing serial numbers.

Thanks Damimkader. I will try and let you know. Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: "Damimkader S. Meeran" Date: Thu, 22 Mar 2012 05:20:05 To: Cc: Subject: Re: $$Excel-Macros$$ Re: Macro for Insert a line for missing serial numbers. Hi, I

$$Excel-Macros$$ Excel formula help needed

Hi Oxford Excel Gurus In the fill attached sheet "P&L" i have been able to write a formula that can show how many number of years i want to view the report ie if i want to see 5 years report i will select from the drop down, and so forth. and the number o years specified will show In the 2nd shee

Re: $$Excel-Macros$$ Re: Macro for Insert a line for missing serial numbers.

Hi, I've modified the code to suit the needs. It has been worked upon in Excel 2007 i unfortunately do not have excel 2010. The code has the following assumptions 1. All serial numbers are in number format. The error message you were getting earlier is possibly because a serial number was a nu

Re: $$Excel-Macros$$ Re: Macro for Insert a line for missing serial numbers.

Dear Damimkader S. Meeran, Thanks for your reply. With ref to your question: I use office 2010 version. And I want to insert 3 column in between (I.e 4,5,6). Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: "Damimkader S. Meeran" Sender: excel-macros@g

$$Excel-Macros$$ Re: Macro for Insert a line for missing serial numbers.

Hi Sandeep, Before I proceed to modify the code, could you let me know the following 1. Which version of excel are you using 2. Do you want the code to insert the rows equivalent to the missing serial numbers for e.g. if after number 3 you have 7, do you want the code to insert 4 rows in the mi

$$Excel-Macros$$ Re: collision of data

On Thu, Mar 22, 2012 at 4:23 PM, Shankar Bheema wrote: > Dear Experts > > I attached an excel workbook. I made my office related form design on > sheet1 of the work book. If the similar form of different kind placed in > sheet2, and if I supply data to the userform relating to the sheet1 will >

$$Excel-Macros$$ creating hyperlink on userform

Dear Experts If a pdf file name is placed on a Label form and assume its location is in D:/. How it would be hyperlinked from the USerform. regards shankar sb -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Hel

Re: $$Excel-Macros$$ checkbox query

Dear Noorain The query solved by Mr KRIS krishnak...@gmail.com is catering my need. Thank you for your cooperation my dear friend. On Tue, Mar 20, 2012 at 6:02 PM, NOORAIN ANSARI wrote: > Dear Shankar, > > Please see attached sheet. > > -- > Thanks & regards, > Noorain Ansari > *http://nooraina

Re: $$Excel-Macros$$ checkbox query

Good evening Sir, Tons for thanks for solving my query by sparing your valuable time. I tried your code and it is removing the options in the datasheet. Whereas, what I want is, at the opening of the datasheet it should have hidden data options and as per the tick marked checkbox data they have

RE: $$Excel-Macros$$ Need help with VBAfor Excel naming and using column names for looping

C is still an important language.. I started out on BASIC, then Clipper and Pascal in the 80s. Learned VB in the 90s as an obvious leap from my most comfortable BASIC background, and besides, I had a need to do Office programming. Played a little with C but never took my programming seriously eno

RE: $$Excel-Macros$$ Need help with VBAfor Excel naming and using column names for looping

You can put anything you want on the first row, but in tables of data (I use the term "tables" loosely here), it is usually desireable to have column headers that describe what data is in each column. Excel has features that use column headers if they exist. For example, sorting and filtering. S

RE: $$Excel-Macros$$ Asa R. I tried what you said for the column addressing but I can not make it work. Can you assist?

Hi again Howard - a few more comments: "First when I used the exact same string as both the Set variable and the Match variable it said it needed an object. It did not like identical names I guess?" By Match variable, I assume you mean the string used in the WorksheetFunction.Match expression.

Re: $$Excel-Macros$$ Re: Match text to a list

This works just as well as the other code but still has the problem, If range (L6:L27) has the letters AA in it then it shows A as a match and says report A is already done On Wed, Mar 21, 2012 at 4:34 PM, Kris wrote: > Hi > > Replace > > Flg = Evaluate("ISNUMBER(LOOKUP(9.**999E+307,SEARCH(D18,

$$Excel-Macros$$ Re: Macro for Insert a line for missing serial numbers.

Dear Damimkader, while I am running this code I am getting the follwing error code run time error 13 type mismatch please help. My problem has been reproduced My current Data is like thisSr. No. S_DISNO S_DISC S_UNIT S_SELP Purchse quantity 495061 358 SILK DUPPATTA 0.90m 260.00 36.0

Re: $$Excel-Macros$$ Need output

Dear Seraj, Please try it.. and see attached sheet. Sub count_name() Dim i, j, c, x As Integer Dim rng As Range c = Sheet1.Cells(Rows.Count, 1).End(xlUp).Row Sheet1.Range("d2 : d" & (c + 1)).ClearContents i = 1 j = 2 x = 1 For j = 2 To c For i = 2 To c If Sheet1.Range("a" & i).Value =

RE: $$Excel-Macros$$ Re: Need help with VBAfor Excel naming and using column names for looping

Hi Howard, It's late here, but you have at least one problem. In the following line: mycolor = cBWTStop.Cells(ActiveCell.Row, ActiveCell.Column).Font.Color you reference the activecell.row and .column; but that gives you the row and column for the active cell relative to the sheet as a whole.

$$Excel-Macros$$ Asa R. I tried what you said for the column addressing but I can not make it work. Can you assist?

Asa, I tried what you said but am doing something wrong. First when I used the exact same string as both the Set variable and the Match variable it said it needed an object. It did not like identical names I guess? Then I created different object names and that would compile but I have tried

$$Excel-Macros$$ Re: Need help with VBAfor Excel naming and using column names for looping

Asa, I tried what you said but am doing something wrong. First when I used the exact same string as both the Set variable and the Match variable it said it needed an object. It did not like identical names I guess? Then I created different object names and that would compile but I have tried s