Tag Info

New answers tagged

0

TL;DR it's not possible as described (cf. this post on SO). Long(er) answer: there's a workaround. The user-defined function must return a Range not an array of value. So the solution is to use a disposable worksheet to "paste" temporary data. Since avoiding temporary data is the exact reason for which I wanted to use an UDF, that's too bad, but it can be ...


0

I would resolve this with the Power Query Add-In. It takes a few steps to get there and a bit of coding in the Power Query language (M) to generate the "running count" needed to get the "cost1/2/3" column headings, and more M code to call the Table.Pivot function (it's not exposed in the Power Query UI). I've built a prototype which you can view or download ...


1

Go into the “Find and Replace” dialog (e.g., type Ctrl+H) and click on the “More >>” button.  Using the “Format” button in the expanded (“Search Options”) part of the dialog box, set the “Find What” format to “Superscript” and the “Replace With” format to “Not Superscript/Subscript”.  Leave the “Find What” field empty, and enter (^&) into the “Replace ...


0

I'm going to assume you know nothing about VBA or macros, so here's the shortest amount of steps to do what you're looking for: Open up your workbook. On your keyboard, hit alt + F11. This will open the VBA developer screen. At the left there is a tree, right click at the top object (VBAProject(YourFileName)) and select Insert > Module. In the module that ...


0

I think its a bug in your code, Len(bworld) should be Len(bword). You should enable Variable declaration required(Option Explicit) in the Vba options. It helps finding such bugs.


0

Instead of using a macro, consider using a function. The function indent-region contains arguments for the beginning and ending of the region. Thus, you could evaluate (indent-region (point-min) (point-max)) to handle the entire buffer. You could also use a simple function to do the same thing: (defun my-format-document () (interactive) ...


0

You may be interested by this Microsoft article. http://msdn.microsoft.com/en-us/library/office/ee704589(v=office.14).aspx


0

Already the most basic level of debugging a macro is useful: This is how to get started; Arrange the prerequisites for running the macro, then press ALT+F11 Look up the macro in any 'Modules' (you might need to open a panel in the View menu to see them), there may also be 'Modules' in several places - one being a 'standard' location, and at least one ...


0

One way to analyze the fault: Use debugging on the macro. Please see my answer here for the very basics.


0

For some reason this question didn't get added as my own so unfortunately I've missed these answers. Anyhow, thank you very much, you understood the problem correctly and found a nice solution. The actual data is quite large, the XP Bands are divided into a lot more categories, table 2 consists of A-G instead of A-B and there are actually 3 different ...


0

Perhaps just use the Selection.Replace method. This line will replace all spaces in the current selection with a comma + space: Selection.Replace What:=" ", Replacement:=", "


0

If I've understood this correctly, you want to Index column 1, Match column 2 to column 5, and Return either the value column 6 or 7, depending on whether the entity is in column 3 or 4 It looks like you want to use Index(Match) to do most of the work, as agtoever suggests. Also he's right on the money with you'll have trouble matching the specific entity ...


0

You've already given the answer. vlookup and index are the right functions to use. My suggestion would be not to try to put it all in one formula/cell but to split the formulae up. Right next to the field in which the Entity name would be entered, do a VLOOKUP for the XP. Next to that, use MATCH to find the category. Finally, use INDEX to find the value ...


0

An Excel Add-in is different than Excel macros. If you want to share one or more Excel Macros, Microsoft has some info about how to do what you really want to do here for one computer and at the bottom of that article, how to share on multiple computers. Typically an Excel Add-in would define custom formulas that you could use in a cell, like "=foo(bar)" ...


0

how to run four macros by click one button? Combine all the code from 1-4 into a new macro, #5, and assign it a shortcut key Create macro #5 to execute macro #1,#2,#3,#4


0

Use the RegReplace Plugin https://www.sublimetext.com/forum/viewtopic.php?f=5&t=4594 I believe it works best in ST3. From http://geeklit.blogspot.com/2013/09/scripting-regular-expressions.html // Test the RegReplace Sublime Plugin "test_reg_replace": { "find" : "testxxxxx", "replace": "it works!" }


0

The customizations disappeared due to unknown reason. To make sure everything is all right I pressed Reset button (also visible on the image in the question above). Now the problem is gone.


2

First, select the text for which you want to ignore spelling in your document. Right click and select Styles > Save selection as a new Quick Style. Then click on Modify and a new window will open named "Create new style from Formatting". Set your font type, font size etc. and then click on the Format button which stands on the lower left corner of the ...


3

a b c d e f 0 0 0 1 0 0 d =INDEX($A$3:$F$3,1,MATCH(1,A4:F4,0)) 0 0 1 0 0 0 c =INDEX($A$3:$F$3,1,MATCH(1,A5:F5,0)) Trust this helps


0

Under Developer -> Visual Basic, put the following in a new module: Sub CopySelection() Dim xlSel As Excel.Range Set xlSel = Excel.Application.Selection xlSel.Copy Excel.Application.Sheets("Sheet2").Range("A1") End Sub Then, under Developer -> Macros, select the sub, click Options, and assign a key.



Top 50 recent answers are included