# Search:

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

Page 1 of 6 1

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

by JenniferMurphy
Replies
8
Views
136

### 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. ## Thread: Best way to skip 1st & last cell in range in UDF?

by JenniferMurphy
Replies
8
Views
136

### 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. ## Thread: Best way to skip 1st & last cell in range in UDF?

by JenniferMurphy
Replies
8
Views
136

### 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. ## Thread: Best way to skip 1st & last cell in range in UDF?

by JenniferMurphy
Replies
8
Views
136

### 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. ## Thread: How to insert multiple rows from one sheet into another

by JenniferMurphy
Replies
2
Views
102

### 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. ## Thread: How to insert multiple rows from one sheet into another

by JenniferMurphy
Replies
2
Views
102

### 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. ## Thread: UDF stops running if I hot-key to another task

by JenniferMurphy
Replies
1
Views
61

### 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. ## Thread: UDF stops running if I hot-key to another task

by JenniferMurphy
Replies
1
Views
61

### 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. ## Thread: how to use a named range in the Offset function

by JenniferMurphy
Replies
9
Views
180

### Re: how to use a named range in the Offset function

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

by JenniferMurphy
Replies
9
Views
180

### 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. ## Thread: how to use a named range in the Offset function

by JenniferMurphy
Replies
9
Views
180

### 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. ## Thread: how to use a named range in the Offset function

by JenniferMurphy
Replies
9
Views
180

### 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. ## Thread: how to use a named range in the Offset function

by JenniferMurphy
Replies
9
Views
180

### 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. ## Thread: Is there any way to emulate non-numeric subscripts in VBA?

by JenniferMurphy
Replies
9
Views
501

### 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. ## Thread: Is there any way to emulate non-numeric subscripts in VBA?

by JenniferMurphy
Replies
9
Views
501

### Re: Is there any way to emulate non-numeric subscripts in VBA?

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

by JenniferMurphy
Replies
9
Views
501

### 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. ## Thread: Is there any way to emulate non-numeric subscripts in VBA?

by JenniferMurphy
Replies
9
Views
501

### 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. ## Thread: Is there any way to emulate non-numeric subscripts in VBA?

by JenniferMurphy
Replies
9
Views
501

### Re: Is there any way to emulate non-numeric subscripts in VBA?

Marcelo,

That looks like exactly what I need. Thank you.

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

by JenniferMurphy
Replies
9
Views
501

### 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. ## Thread: Help processing a named array in a UDF

by JenniferMurphy
Replies
7
Views
341

### 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. ## Thread: Help processing a named array in a UDF

by JenniferMurphy
Replies
7
Views
341

### 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. ## Thread: Help processing a named array in a UDF

by JenniferMurphy
Replies
7
Views
341

### 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. ## Thread: Help processing a named array in a UDF

by JenniferMurphy
Replies
7
Views
341

### 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. ## Thread: Still baffled by the Intersect operator

by JenniferMurphy
Replies
2
Views
180

### 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. ## Thread: Still baffled by the Intersect operator

by JenniferMurphy
Replies
2
Views
180

### 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