VBA-Excel 320

Visual basic for applications that works only in Microsoft Excel, aka macros

Sorted from new to old.

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May31

MatchIf5Up

Searches for five cells in five columns and return the row number if all found ...

May27

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

May27

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

May16

MatchIF5

Searching for rows having 5 values in 5 columns Like

May6

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

May1

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

Apr29

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

Apr19

ANmaCellFormat

Reads or set Numberformatting for a cell or range. Can pass sheet and workbook ...

Apr18

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

Apr17

ListBox bug with TabIndex

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

Apr15

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

Apr15

MatchIfUp or MatchIfRev

Searching for an item in a column from bottom to top. Will search for item in ...

Apr8

ContainerHTMLTag_ReturnBlock

Returns the full string starting from open tag of container where LocationIndex ...

Apr3

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Mar14

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

Mar12

1 2 3 ...19 20