Search results 61

Sorted from new to old.

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

May10

MathInsideText

Return string after applying math to each number found inside the string. ...

May8

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

May2

FirstDuplicatedItem

Returns the value of first duplicated item found in a range. This is to ...

Apr18

ANmaRow_Duplicate1

Duplicate 1 row into row below with insert using fill down or copy-paste No ...

Apr17

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

Apr10

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

Mar24

ListItemText_to_ListIndex

Finds the index of an item in listbox (or combobox) It searches for that item ...

Mar24

NumberBeforeString_HTML2

Cuts a number that would be found 2 words before certain word inside a block ...

Mar20

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

2024Jul13

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

Webfont generater

Online tool. Generate web font to be used in websites. When trying to fix ...

2023Nov27

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

1 2 3 4