$$Excel-Macros$$ Re: equation editor in excel 2010

Santiago Afonso wrote: Hello. I'd like to use the equation editor in excel 2010 through VBA. In Word, the equation object is OMath ( http://msdn.microsoft.com/en-us/library/bb256563%28office.12%29.aspx), and the macro recorder records some actions done to such an object (like changing

Re: $$Excel-Macros$$ Re: Problem In Macro Recording (URGENT Plz ! )

Thanx REHAN On Sat, Jul 31, 2010 at 11:54 AM, Kishan Reddy, K kishanreddy.kethire...@gmail.com wrote: Just open the workbook in which you have created the macro. It will work in generally. Regards, Kishan Reddy, K On Jul 30, 2:32 pm, Rehan Baig rehan.bai...@gmail.com wrote: Kishan

RE: $$Excel-Macros$$ Sort and then extract digits from 7 to 25

Hi Skanda, Using worksheet funtions, it would just be: =MID(B6,7,19) copied down. Programatically it would include a For/Next loop, but the otherwise look very similar: Sub SevenToTwentyfive() For i = 6 To 1000 Cells(i, 3) = Mid(Cells(i, 2), 7, 19) Next i End Sub This

$$Excel-Macros$$ Re: Sort and then extract digits from 7 to 25

Hi Skanda, It probably looks something like this (you may have to tweak the Row/ Column values depending on the overall structure of your worksheet) Sub Select_Char7to25() ' ' Application.Goto Reference:=R6C2 Range(B6).Select ActiveCell.FormulaR1C1 = =MID(RC[-1],7,19)

Re: $$Excel-Macros$$ Format Problem

Looks like a part of the content in the file is corrupt..and cannot be repaired Regards, Andy On Mon, Aug 2, 2010 at 3:56 PM, Deepak Rawat deepakexce...@gmail.comwrote: Hi all This is a excel file and its not opening normally can anybody fix the problem. Regards, Deepak --

$$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1

Forgot the attachment, sorry :) 2010/8/2 Angelo Spinola spinolaang...@gmail.com Hello All, I need a formula that Checks if B,C, D are the sameif equal (could have more than just two equal) sums the Columns E and F and replace it for just one Line instead of having duplicates or

$$Excel-Macros$$ URGENT: Sum of 2 Lines replaced by 1

Hello All, I need a formula that Checks if B,C, D are the sameif equal (could have more than just two equal) sums the Columns E and F and replace it for just one Line instead of having duplicates or triplicates. How can i create this ? With a Macro ? Regards. --

$$Excel-Macros$$ Mastering Excel macros

Dear Team members, I have joined the below google group which is very useful for us. As a member in coreteam, we mostly use excel. This group is very useful to learn advanced features of excel. *excel-mac...@googlegroups.com.* If you have any problem in excel, you can join and post in this

Fwd: $$Excel-Macros$$ Re: automation error

hi all, can anybody help me out in sovin the below problem. -- Forwarded message -- From: mohd ateeq atee...@gmail.com Date: Thu, Jul 29, 2010 at 9:25 PM Subject: Re: $$Excel-Macros$$ Re: automation error To: excel-macros@googlegroups.com Thanks a lot stuart... Actually i

Re: $$Excel-Macros$$ Re: Sort and then extract digits from 7 to 25

Sid, How do i use this in the existing code?As how to call it etc tec Skanda. On Mon, Aug 2, 2010 at 5:27 AM, Sid. simon_mc_webs...@yahoo.co.uk wrote: Hi Skanda, It probably looks something like this (you may have to tweak the Row/ Column values depending on the overall structure of your

Re: $$Excel-Macros$$

Dave, Thank you so much.  This works!  You don't know how thankful I am.  I needed that peice before I could move forward with a workbook.  Thank you!!! Nadine From: Dave Bonallack davebonall...@hotmail.com To: excel-macros@googlegroups.com

$$Excel-Macros$$ Sumproduct with 3 criteria +

I have a workbook that needs a sumproduct. I have: =SUMPRODUCT(('Sheet3'!$A$2:$A$1000='Summary'!$F2)*('Sheet3'!$B$2:$B$1000='Summary'!$G2)*('Sheet3'!$C$2:$C$1000='Summary'!$H2)*('Sheet3'!$AD$2:$AD$1000='Summary'!R$4),('Sheet3'!$AB$2:$AB$1000)) What I need is a total of the result of that plus

$$Excel-Macros$$ pdf to excel

hi all, i am preparin a macro in which i need to extract the data from pdf file and then make necessary changes accordin to the requirement. can you please help me out as to how i should extract the data from pdf through vba. thanks in advance saber --

RE: $$Excel-Macros$$ Re: URGENT: Sum of 2 Lines replaced by 1

Hi Angelo, The summing could be done with worksheet functions - probably SUMPRODUCT. But the deleting of lines has to be done by macro, so it makes sense to do both by macro. I can't look at it straight away, but if no one else comes up with anything, I'll have a look later. Regards - Dave.

Re: $$Excel-Macros$$ Arithmetic with blank cells

I like Dave's answer. It seems to work the best. Thanks. On Sun, Aug 1, 2010 at 1:28 AM, Dave Bonallack davebonall...@hotmail.comwrote: Hi, Try changing the formula in M3 to: IF(COUNT(M1,M2)0,*SUM(M1:M2)*,) I think *M1+M2* is the problem. The '+' operand can't seem to handle