Replies

The add-in is installed as you described via ToolsAdd-ins and checking the box. If I change the function name in the workbook and the add-in, Excel executes the function correctly.

I’ve always noticed that with UDFs, the case of the UDF name (i.e. which letters are capitalized in the name) is determined by your first usage of the UDF in your workbook. This makes me believe that Excel is building a table of UDF names.

In my current situation, the function name continues to revert to all lower case because that’s how it was originally used in the workbook, even though I’ve deleted the UDF from the workbook, opened the workbook, deleted references to the function, removed the add-in, saved the workbook, and re-installed the add-in all in an attempt to delete this entry from this presumed UDF name table.

Thanks so much, Hans. This works perfectly now. I suspect that this has been my core problem causing all of my posts in the Access board recently. I assumed that CurrentDB behaved just like ActiveWorkbook in Excel VBA.

Thanks so much, Hans. This works perfectly now. I suspect that this has been my core problem causing all of my posts in the Access board recently. I assumed that CurrentDB behaved just like ActiveWorkbook in Excel VBA.

I think Get External Data will only work if your source data is organized as a database (i.e. records and fields).

When you link to other spreadsheets, you don’t need to send all of the source spreadsheets when you want to distribute your own work. You do have to instruct people to not attempt to update links when they open your spreadsheet. All of the linked values should stay as they were when you saved your file.

I think Get External Data will only work if your source data is organized as a database (i.e. records and fields).

When you link to other spreadsheets, you don’t need to send all of the source spreadsheets when you want to distribute your own work. You do have to instruct people to not attempt to update links when they open your spreadsheet. All of the linked values should stay as they were when you saved your file.

I think you just need parentheses:

If Not (var_DESCR = “RIMBORSO FINANZIAMENTI” Or var_DESCR = “VERSAMENTO ASSEGNO DI CONTO CORRENTE” Or var_DESCR = “GIROCONTO” Or var_DESCR = “UTILIZZO CARTA CREDITO”) Then

The way you have it currently written, the NOT is only applied to your first test (RIMBORSO FINANZIAMENTI).

Make sure you have selected one of your data series before trying to change the axis. If you are trying to format the entire chart, the secondary axis option won’t be available to you.

Make sure you have selected one of your data series before trying to change the axis. If you are trying to format the entire chart, the secondary axis option won’t be available to you.

I’ve attached an example that is more generalized which might be useful. It uses conditional formats to highlight the 3 most popular answers for each question, each in different colors.

I’ve attached an example that is more generalized which might be useful. It uses conditional formats to highlight the 3 most popular answers for each question, each in different colors.

I would agree with John and Steve on this.

Just to add one more thing. In general, you do have to be careful with your absolute and relative cell references when copying conditional formats. John’s conditional format formula doesn’t have any absolute vs. relative reference issues.

I would agree with John and Steve on this.

Just to add one more thing. In general, you do have to be careful with your absolute and relative cell references when copying conditional formats. John’s conditional format formula doesn’t have any absolute vs. relative reference issues.

One of the problems with Autofilter is that the dropdown box has a limit of 1000 unique values, so if you have more than 1000 hymn numbers, it won’t be so easy for your boss to pull them up.

I’ve attached a worksheet that uses the LARGE function. You type the hymn number in the yellow cell and then cells G4:G8 contain the 5 largest (i.e. most recent) dates that the hymn was used. You can copy the function more than 5 times if you want the 20 most recent or whatever. Each formula in G4:G8 is an array formula so you need to press ctrl-shift-enter to complete the formula.

One of the problems with Autofilter is that the dropdown box has a limit of 1000 unique values, so if you have more than 1000 hymn numbers, it won’t be so easy for your boss to pull them up.

I’ve attached a worksheet that uses the LARGE function. You type the hymn number in the yellow cell and then cells G4:G8 contain the 5 largest (i.e. most recent) dates that the hymn was used. You can copy the function more than 5 times if you want the 20 most recent or whatever. Each formula in G4:G8 is an array formula so you need to press ctrl-shift-enter to complete the formula.

Hans and Mark,
Thanks for the replies. I think both are workable ideas and I shouldn’t have too much trouble implementing either one.