Search results 91

Sorted from new to old.

Range().top below hidden rows

Hidden rows change the .top of below ranges. It turns out that the range().top ...

Jan13

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

2025Aug7

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

2025Jun14

FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

2025May25

MatchIf8

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

2025May10

MatchIf8Up

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

2025May7

ANmaUploadFTP_FilesFrom2Columns

Upload files in column each to folder in next column. Expects to have two ...

2025May4

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

2025May3

MatchIf7

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

2025May2

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

2025Apr12

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

2025Mar11

HTMLTable_FindTable

Reads < table .... < /table> found after index Have ability to opnly bring the ...

2025Jan12

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

2025Jan8

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

1 2 ...5 6