excel-2010_开发者

How to make an XLAM UDF call portable?

It seems that when I call a UDF in an XLAM file, the path to the XLAM file is embedded in the spreadsheet.When I open the spreadsheet from another machine (which has the same XLAM add-in installed, ju[详细]

2023-04-13 07:37 分类：问答

Library to parse Excel Formulas

I\'m looking to make an AddIn for excel that modifies formulas in cells. Looking at Microsoft\'s C# and VBA API, I don\'t even see a Formula object. All I can get is the string that is displayed. Is t[详细]

2023-04-13 03:05 分类：问答

How can I get intellisense to work for UDFs in XLAM files?

I have some UDFs in an XLAM file.Intellisense doesn\'t seem to pickup these UDFs when the XLAM is installed as an add-in.The UDFs themselves work fine in Excel, its just that they don\'t appear in int[详细]

2023-04-13 01:44 分类：问答

Expression to test for one or more spaces in VBA to find matches in Excel cells

I am trying to use regular expressions in a macro for an Excel document. Here is what I have so far:[详细]

2023-04-12 15:49 分类：问答

Reverse a 1d array output from a function (or get the last value), without VBA?

Suppose I have a UDF MyFunc() which is too costly to call more than once, MyFunc() returns an array.By default, if applied to a single cell then the first value in the arr开发者_StackOverflow社区ay is[详细]

2023-04-12 09:28 分类：问答

Custom Additional Cell Actions in Excel 2010

I\'d like to extend the MS Excel 2010 by adding some more \"Additional Cell Actions\". (accessible via cell right-click > Additional Cell Actions). Sp开发者_运维百科ecifically, I\'d like Excel to:[详细]

2023-04-09 06:25 分类：问答

Macro does not work in a duplicate worksheet

Good morning. I have a Microsoft Excel Macro Enabled Workbook with two worksheets: let\'s say Sheet1 and Sheet2. In Sheet2 I have a combo box (form control) that works as a table sorter. This table wi[详细]

2023-04-08 20:29 分类：问答

Excel VBA to insert line until text is matched

I\'ve got an Excel file that should have the text \'UNK\' as the first 3 letters开发者_如何学Python of cell A10 (I don\'t care what comes after the UNK). If it does NOT match this text, I need to inse[详细]

2023-04-08 17:49 分类：问答

Using Cubeset To Create Top 10 Items List For a Specified Time Period

I am using Excel 2010 to create a list of the top 10 vendors by sales during a specified time period. The catch is that I need to consider only customers that are a member of a particular set. I found[详细]

2023-04-07 19:08 分类：问答

Ms Excel VBA: Set a sorting combo box

I am new to VBA although I have some experience in Visual Basic. I have a Microsoft Excel 2010 worksheet. Row 29 has the headers of a table and the data is from row 30 and so on. This table has like 2[详细]

2023-04-07 18:22 分类：问答