|
More site info...
microsoft.public.excel.programming | Forum profile
|
|
Forum profile page for microsoft.public.excel.programming on http://www.microsoft.com/communities/newsgroups....
This report page is the aggregated overview from a single forum: microsoft.public.excel.programming, located on the Message Board at http://www.microsoft.com/communities/newsgroups....
This forum profile page summarizes the general forum statistics such as: Users Activity, Forum Activity, and Top Authors, which are reported in either a table or graph below for a given reporting time period.
Additional forum profile information for "microsoft.public.excel.programming" on the Message Board at http://www.microsoft.com/communities/newsgroups... is also shown in the following ways:
1) Latest Active Threads
2) Hot Threads for Last Week
Warning: These statistics are generated using 'best efforts' and can experience delays and reporting errors at times. Please note that such statistics do not constitute a forum's popularity and/or exact posting volumes at any given reporting period.
|
|
|
|
|
Posting activity on microsoft.public.excel.programming:
|
|
Week
|
Month
|
3 Months
|
|
Threads:
|
313
|
1,112
|
4,520
|
|
Post:
|
1,057
|
3,553
|
13,768
|
|
|
microsoft.public.excel.programming Posting activity graph:
|
Top authors during last week:
user's latest post:
Trying to evaluate cell...
Published (2009-01-08 12:41:00)
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"...
user's latest post:
.Sort.SortFields in...
Published (2009-01-08 12:57:00)
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...
user's latest post:
problem when creating a series...
Published (2009-01-08 11:17:00)
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...
user's latest post:
Programmatically adding a...
Published (2009-01-08 10:13:00)
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...
user's latest post:
Fastest way to create clickable...
Published (2009-01-08 12:12:00)
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 -...
user's latest post:
Programmatically adding a...
Published (2009-01-08 10:26:00)
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...
user's latest post:
How to initiate a sound via VBA?...
Published (2009-01-08 13:05:00)
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 >...
user's latest post:
problems adding botton to a menu...
Published (2009-01-08 03:48:00)
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...
user's latest post:
Problem with .TintAndShade in...
Published (2009-01-08 11:39:00)
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...
user's latest post:
Macro or formula in...
Published (2009-01-05 15:20:00)
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: >...
|
|
|
|
Latest active threads on microsoft.public.excel.programming::
Started 11 hours, 59 minutes ago (2009-01-08 12:59:00)
by Hartmut (Harry) Kloppert
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 "Beep" in VBA. But that (of course) gives me a lot of strange sounds at many other windows-events...) Hary...
Started 12 hours, 45 minutes ago (2009-01-08 12:13:00)
by Heera
Hi All, I am seriously in a problem. I have recorded a macro which pull's out data from a database with the help of MS query. The user of this macro will pull the data from a specific date to a specific date and for that I have applied filter in the query itself. But my problem comes when I try to fire the query ...
Started 12 hours, 48 minutes ago (2009-01-08 12:10:00)
by Andrew Glennie
Hi All, I am working on a highly customised Citrix environment in which my Excel toolbar setting won't stick. I wish to have the Standard and Formatting toolbars in 2 rows, and the Drawing toolbar running as well. As I am somewhat tired of having to do this manually every time, I am hoping there is code to at least set the ...
Started 13 hours, 29 minutes ago (2009-01-08 11:29:00)
by MESTRELLA29
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 the selected range insted of the Raneg Set by the recorded macro. Range("A11").Select Range(...
Started 12 hours, 37 minutes ago (2009-01-08 12:21:00)
by meg99
using 2003. In the editor I see the macro comments are colored green. Is it possible to have it print that way as well? meg99
Started 15 hours ago (2009-01-08 09:58:00)
by johannes.liss@gmail.com
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 like new matrix for every new months (moving one month at a ...
Started 13 hours, 47 minutes ago (2009-01-08 11:11:00)
by JeffC
I have a formula that takes a few parameters. For one of the string parameters I want to concatenate values from cells in the spreadsheet directly in the formula. For example cell A1 = Bob cell B1 = Smith In another cell I call my formula =My_formula("Name", A1 & " " & B1). When I press enter on this, my formula is ...
Started 13 hours, 15 minutes ago (2009-01-08 11:43:00)
by Charles
Hi there I am generating worksheets in VBA with lots of buttons, i.e. cells that launch a macro when clicked. The neatest way I found so far is to create a rectangular shape to which I assign an "onaction" property. The thing is that I need to add a lot of them in a spreadsheet (a few hundreds at least), and it is slowing down my...
Started 13 hours, 10 minutes ago (2009-01-08 11:48:00)
by pkeegs
I have the following code in a Macro to refresh an external database query. Sheets("Client & Staff Data").Select ActiveSheet.Unprotect Password:=" pancake" ActiveWorkbook.RefreshAll Range("M3:N3").Select Selection.AutoFill Destination:=Range("M3:N98"), Type:=xlFillDefault ...
Started 19 hours, 22 minutes ago (2009-01-08 05:36:00)
by Saucer Man
I want my excel workbook to have the greenbar effect starting with row 4. I have 12 worksheets in the workbook. I would like the sheets to have this effect as the data is being entered row by row daily. How can I do this? -- Thanks!
|
|
Hot threads for last week on microsoft.public.excel.programming::
Started 1 day, 16 hours ago (2009-01-07 08:20:00)
by Carim
Hi, In a class module, within a Private Sub ButtonGroup_Click() , I cannot have the Application.Evaluate to execute itself ... I am stuck with these two lines : Back2Top = "CommandButton" & z & "_Click" Application.Evaluate (Back2Top) Thanks a lot for your help and Happy New Year Cheers...
Started 1 week ago (2009-01-01 13:19:00)
by DTrader
I am a day trader doing trading system research. I can't get a formula to work out on both sides for a positive result =IF(OR(D2,1),(H2-E2),IF(OR(D2,2),(E2-H2))) I would also like 'D' to calculate based on it's letter entry, B/S =IF(OR(D2,B),(H2-E2),IF(OR(D2,S),(E2-H2))) D E F...
Started 3 days, 10 hours ago (2009-01-05 14:07:00)
by santaviga
Hi, I am looking for a formula or macro so that when an active cell is selected lets say cell A3 is selected excel will automatically go to a sheet number specified say Sheet 3. Any help would be much appreciated. Regards
Started 3 days, 13 hours ago (2009-01-05 11:38:00)
by cvgairport
Hi there, Can a VB macro be written to hide 3 rows at the cell position - no matter where the current cell position is. I can write a macro to select specific row numbers, but I want one that will take the 3 rows from the current cell. Thanks! Amy
| |