microsoft.public.excel.programming | Forum profile

  I'm not 100% sure I understand your question. Does this do what you want (assuming the formula is in A3)? Frmla = Range("A3").Formula Arg = Application.Evaluate(Trim(Split(Split(Frmla, ",")(1), ")")(0))) How you get to the actual argument may change depending on the actual formula that is being parsed. -- Rick (MVP - Excel) "JeffC"...

  with selection .Cells.Sort key1:=.Columns(1), order1:=xlAscending, _ Header:=xlno, MatchCase:=False, Orientation:=xlTopToBottom End with MESTRELLA29 wrote: > > Problem... I am downoading mi data to excel, after that I have this macro > that sorts the information by coulum A, but it is only sorting .SetRange > Range("A11:N95"), this is ther range when i created the macro, how do I sort...

  Don't use a calendar month, instead use a 30 day month. "johannes.liss@gmail.com" wrote: > I would like to create a number of matrixes from a list (covariance > between assets over time). > I put =MMULT(TRANSPOSE(O2:S25);O2:S25)/24 in excel and get a 5x5 > covariance matrix calculated > on the dates 9301-9412 (January 93 until December 94 - 24 > observations). I would...

  Was the apostrophe included when you ran the code with the type specified? It should works if the constant is spelled correctly and there are no superflous symbols included. "Maury Markowitz" wrote: > I had this working before, but now I can't get the syntax correct... > > I am looping over a series of cells in a column and adding a formula > to fetch the latest price from...

  You don't need a separate button for each macro. Setup a list of the macros in some column. Thenset Data Validation on some cell, say B9, to pick from the list. The have an event macro monitor B9 and call the selected macro for you: Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Range("B9"), Target) Is Nothing Then Exit Sub Application.Run Target.Value End Sub -- Gary''s Student -...

  Following worked for me Sub test() Dim bbgcol As String, i As Long Dim sFml As String Dim rng As Range bbgcol = "C" i = 4 Set rng = Range(bbgcol & i).Offset(, 1) rng.Offset(, -1) = "#abc" sFml = "=LEFT($" & bbgcol & "$" & i & ",1)=""#""" rng.FormatConditions.Delete...

  Hi, You can find out how here http://www.j-walk.com/ss/excel/tips/tip59.htm Mike "Hartmut (Harry) Kloppert" wrote: > At a certain event (push button) I would like to have > a sound (.wav) file being played. > Any advise? > > (for a test, I reconfigured the "Default Beep" in Windows > to the desired wav-ile. And then programm a simple >...

  If you want one of Excel's images, you just need to set the FaceId property. If you want a custom image, you need to save it in your workbook, copy and paste it in. -- __________________________________ HTH Bob "filo666" <filo666@discussions.microsoft.com> wrote in message news:BF0637A7-7308-42C0-9859-3ED8983A66E8@microsoft.com... > Thnaks, It worked perfectly; > > other...

  I agree that it is a version issue. I couldn't make TintAndShade work with borders in any way on Excel 2003. The Object Browser confirms that this is not a property of a Border object. In 2007, the code works and the Object Browser confirms that TintAndShade is a property of a Border object. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group, 1998 - 2009 Pearson Software Consulting, LLC...

  Sorry, but I don't understand what you mean with "do this through 150 cells to 150 sheets". Could you please explain. Lars-ke On Mon, 5 Jan 2009 15:06:00 -0800, santaviga <santaviga@discussions.microsoft.com> wrote: >Got it working thanks, is there a quick way to do this through 150 cells to >150 sheets? > > >"Lars-ke Aspelin" wrote: >...