Search:

Type: Posts; User: JenniferMurphy; Keyword(s):

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Re: Best way to skip 1st & last cell in range in UDF?

    The processing is nothing simple like that.


    Perhaps, but often necessary.


    I never said anything about either of those objectives.
  2. Re: Best way to skip 1st & last cell in range in UDF?

    Perfect. And I can get the value in each cell as text using:


    Ratings(i).Text


    Thank you
  3. Re: Best way to skip 1st & last cell in range in UDF?

    It's doing all of that and more. But what difference does that make? I want the UDF to step through each of the cells in the range skipping the first one and the last one?
  4. Best way to skip 1st & last cell in range in UDF?

    I have a little UDF that does some tallies on a column of cells (B2:B5).


    <tbody>
    R/C
    A
    B


    1
  5. Re: How to insert multiple rows from one sheet into another

    Thank you. That works perfectly.

    I would update your instructions a bit to this:

    To copy or move a range of rows or columns and insert them between two existing rows or columns, use the Insert...
  6. How to insert multiple rows from one sheet into another

    Is there a way that I can insert a range of rows (18:35) from Sheet1 in between rows 17 & 18 in sheet2?

    Everything I have tried ends up replacing at least one row in the target sheet. I suppose I...
  7. Re: UDF stops running if I hot-key to another task

    Ooopppsss. I was wrong. The UDF does not stop running. It's something to do with the InputBox. If I hot-key just as it is being displayed, Excel goes into a funny mode where the Icon in the Taskbar...
  8. UDF stops running if I hot-key to another task

    I have a UDF that does some iterative calculations. It can take anywhere from about 2 to 8-10 seconds to complete its work. The data, which I enter into an InputBox, comes from another application....
  9. Re: how to use a named range in the Offset function

    Perfect. Thank you very much
  10. Re: how to use a named range in the Offset function

    That's an interesting solution. I hadn't thought of that. It would make this formula work, but would cause all my others to fail.


    Yes, but as I already said, this misses the main point. I am...
  11. Re: how to use a named range in the Offset function

    Of course.


    Not at all.

    I assigned the name "Price" to column D and "Shares" to column E. The formulas in F6:F8 are all "=Price*Shares". That formula is able to use the values in the named...
  12. Re: how to use a named range in the Offset function

    I named the range (column) because I want to use named addressing, not literal addressing. I want to use the name "Balance" in some formula that will calculate the difference between the balance in...
  13. how to use a named range in the Offset function

    In the table below, I have assigned the name "Balance" to column F. I would like to replace "F6" in I6 with the named range, "Balance", but the offset function doesn't like it.


    <tbody>
    R/C

    C...
  14. Re: Is there any way to emulate non-numeric subscripts in VBA?

    The dictionary variables are working great. Thanks for that tip. Here's a section of that code.


    Function TallyResults(Results As Range, Player As String, GSM As String, WL As String)

    Dim rRow...
  15. Re: Is there any way to emulate non-numeric subscripts in VBA?

    That fixed it. Thanks. I misunderstood that part of the tutorial.
  16. Re: Is there any way to emulate non-numeric subscripts in VBA?

    I copied those examples and they get errors:



    Function TallyResults(Results As Range, Player As String, WL As String, GSM As String)

    Dim dict As New Scripting.Dictionary 'Error

    'or
  17. Re: Is there any way to emulate non-numeric subscripts in VBA?

    I think I followed the instructions exactly, but I am getting an error. Here's the code. The error is indicated in the comment on line 7. I then copied the exact code from the example and it also...
  18. Re: Is there any way to emulate non-numeric subscripts in VBA?

    Marcelo,

    That looks like exactly what I need. Thank you.

    -j
  19. Is there any way to emulate non-numeric subscripts in VBA?

    I need to tally some results for tennis players. Is there any way in Excel to emulate an array with non-numeric subscripts?

    If I am reading data from a table with results for "Eliza", "Susie", and...
  20. Re: Help processing a named array in a UDF

    Great. This code seems to be working.



    Function TallyResults(Results As Range, Options As String)

    Dim rRow As Range
    Dim Winner, Loser, Set1, Set2, Set3 As String
    Dim iRow As Integer
  21. Re: Help processing a named array in a UDF

    That seems to work. Thanks.

    I forgot one thing. The named range, "Results", actually includes a header row at the top and a summary row at the bottom that I want to skip over. Do I change the For...
  22. Re: Help processing a named array in a UDF

    Great, thanks. Is rRow a variable or a keyword? If it's a variable, how do I declare it?
  23. Help processing a named array in a UDF

    I would like to write a UDF that will examine the contents of each cell in a named array and return various results. The array contains the scores of tennis matches between players on a club tennis...
  24. Re: Still baffled by the Intersect operator

    Perfect. The actual expression I need is,

    =INDEX(NumTrials,ROW(G6)+1)*PR_AA

    But why don't any of these work?



    =NumTrials (ROW(G9)+1):(ROW(G9)+1)
    =NumTrials ((ROW(G9)+1):(ROW(G9)+1))
  25. Still baffled by the Intersect operator

    This table has some data from an analysis of the game of tennis. Row 4 shows the names assigned to each column. Columns D & E are assigned the names PGS_A & PGS_B, which stands for the probability of...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4