# Search:

Type: Posts; User: Dr. Demento; Keyword(s):

Page 1 of 6 1

1. ## Thread: Pasting linked range or chart from Excel to PowerPoint

by Dr. Demento
Replies
1
Views
79

### Pasting linked range or chart from Excel to PowerPoint

I'm having trouble finding an example of the method of pasting a range or chart from Excel into PowerPoint as a linked object. A link would be great.

Thanks y'all.
2. ## Thread: Calculate Day Name in a Month and then Average

by Dr. Demento
Replies
1
Views
83

### Re: Calculate Day Name in a Month and then Average

You can find two solutions here and here.
3. ## Thread: Reference table using cell value in INDEX/MATCH formula

by Dr. Demento
Replies
2
Views
94

### Re: Reference table using cell value in INDEX/MATCH formula

Jason,

Thanks so much. It wasn't precisely what I needed, but it was dang close!

Here's my final formula:

...
4. ## Thread: Reference table using cell value in INDEX/MATCH formula

by Dr. Demento
Replies
2
Views
94

### Reference table using cell value in INDEX/MATCH formula

I'm putting together a master list of phone numbers across the US. In order to keep things neat, each state is on a different sheet. Rather than change the formula 50x, I'm curious how I could...
5. ## Thread: Average or occurrences help needed

by Dr. Demento
Replies
7
Views
266

### Re: Average or occurrences help needed

Not sure how accurate you need to be with your average calculation, but to average rates you need to use the harmonic mean not arithmetic mean.
...
6. ## Thread: Excel related, but not formulas or visual basic

by Dr. Demento
Replies
4
Views
1,092

### Re: Excel related, but not formulas or visual basic

That is strange!! I'm afraid you've just outstripped my usefulness!!!
7. ## Thread: Sub quits on Dropdown.OnAction assignment

by Dr. Demento
Replies
2
Views
167

### Re: Sub quits on Dropdown.OnAction assignment

Thank you! What was gacking it up was the fact I was attempting to both create the shape and assign it to a dropdown in the same line. Separating them into two lines made it work.

Thanks again.
8. ## Thread: Sub quits on Dropdown.OnAction assignment

by Dr. Demento
Replies
2
Views
167

### Sub quits on Dropdown.OnAction assignment

I'm running a sub from PERSONAL.XLSB that assigns a DropDown to the active sheet. Below is how it's being assigned.

Dim ddFilterDropDown As dropdown
' Add a new filter dropdown
Set...
9. ## Thread: Sheet codename order in VBE

by Dr. Demento
Replies
5
Views
207

### Re: Sheet codename order in VBE

Fluff is correct; I was looking at the VBE Projects window.

Appreciate the feedback.
10. ## Thread: Sheet codename order in VBE

by Dr. Demento
Replies
5
Views
207

### Sheet codename order in VBE

I have a large number of worksheets (>200) and because Excel places the sheets in order of codename and because the codenames are alphanumeric, I wind up with an order like Sheet1, Sheet100,...
11. ## Thread: Converting all files that can be read by MS Word into TXT files

by Dr. Demento
Replies
1
Views
68

### Converting all files that can be read by MS Word into TXT files

The goal is to convert any file that can be read by MS Word and convert it directly (and hopefully quickly) into a text file. I swear I had this working at one point but it's certainly not working...
12. ## Thread: Loop thru UNSAVED open text files

by Dr. Demento
Replies
0
Views
73

### Loop thru UNSAVED open text files

So I do a report where I "download" a number of text files but I do not save them. My goal is to loop thru all open text files, copy the contents, and based on the filename (which I would have to...
13. ## Thread: (Re-)assigning VBA Editor Shortcut Keys

by Dr. Demento
Replies
2
Views
218

### Re: (Re-)assigning VBA Editor Shortcut Keys

Apologies for the late response. My issue is that I want to program a shortcut key within VBE to run a custom sub; given your example, I could conceivably (recognizing this would be a terrible idea)...
14. ## Thread: (Re-)assigning VBA Editor Shortcut Keys

by Dr. Demento
Replies
2
Views
218

### (Re-)assigning VBA Editor Shortcut Keys

I understand how to assign shortcut keys in Excel, but I'm coming up blank on how to run a Sub while in the VBE using a shortcut key.

Thanks y'all.
15. ## Thread: Assign Code to Numbers

by Dr. Demento
Replies
7
Views
314

### Re: Assign Code to Numbers

If you have "millions of records," may I recommend using an array instead of either a UDF (Rick's suggestion) or theBardd's formula; both of these will take an inordinate amount of time and no...
16. ## Thread: Calculating months if all days count (DATEDIF)

by Dr. Demento
Replies
4
Views
253

### Re: Calculating months if all days count (DATEDIF)

I don’t know this formula very well, but it seems that someone else had a similar problem with inclusive dates. Perhaps this will help.
...
17. ## Thread: Running total that resets

by Dr. Demento
Replies
12
Views
771

### Re: Running total that resets

I figured out the answer to question 2; and assumed that it was a string output. Still don't know what's going on in series 178.

In case this is handling a large dataset, I used arrays instead of...
18. ## Thread: Counting number of text strings in a cell

by Dr. Demento
Replies
19
Views
699

### Re: Counting number of text strings in a cell

If each country is separated by a delimiter (in this case a comma), this formula will count the number of delimiters plus 1.

=LEN(TRIM(A1))-LEN(SUBSTITUTE(TRIM(A1),",",""))+1

Never mind - I...
19. ## Thread: Running total that resets

by Dr. Demento
Replies
12
Views
771

### Re: Running total that resets

I have some code that I think will work, but my output is a little different than yours.

For one, are the values in column E a single concatenated string of the boxes or does each box (A, B, C,...
20. ## Thread: Index(Match) Issue being annoying/dumb

by Dr. Demento
Replies
3
Views
271

### Re: Index(Match) Issue being annoying/dumb

Sounds like a refresh problem.

https://support.office.com/en-us/article/Refresh-data-connected-to-another-workbook-EB189DE2-A420-41D2-851E-B9C8AC058D35

by Dr. Demento
Replies
9
Views
402

### Re: Workbook Name

That’s actually a straight forward fix. Instead of defining the new name as you assign it to the file name, simply assign it to a string variable first. That way you can put it in the file name and...

by Dr. Demento
Replies
7
Views
483

### Re: sequence

There are some details you haven't covered about the final format you'd like, but here's one solution
The first time a new person's name is listed, hardcode their number (a=1, b=2, c=3, etc). In...

by Dr. Demento
Replies
9
Views
402

### Re: Work book Name

Using the code linked to the SEND button, you must have some code that indicates the new file location. By appending that with the following, it should get you close to what you need.

Dim...
24. ## Thread: Excel related, but not formulas or visual basic

by Dr. Demento
Replies
4
Views
1,092

### Re: Excel related, but not formulas or visual basic

Not sure why it's doing it, but if you put the following code in your PERSONAL.XLSB file, it will loop thru all open workbooks and make them visible when Excel opens.

Private Sub Workbook_Open()...
25. ## Thread: Range Data formating texttocolumns

by Dr. Demento
Replies
2
Views
172

### Re: Range Data formating texttocolumns

Actually, a little trial showed that if I chose the TtoC date format that the date is actually in (25/1/2019 = DMY), then the output was into whatever my system default is or you can change the...
Results 1 to 25 of 150
Page 1 of 6 1