Search results 100

Sorted from new to old.

ANString_to_ListSelects

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

Mar24

TemplateLine_10Xs

Two functions to automate the replacing of variables inside a long string. Up ...

Mar16

ListBox_Read and ListBox_Save

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

Mar11

ToggleCells

Toggle a value through list of cells in a range Pass current value and range ...

Feb2

ANStrFind_AndOrRemove

Checks (and/or removes) if an item was found in list of items and return 1 if ...

Jan12

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

Jan8

ANmaSum_5IFs

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

Jan8

Match6_Until

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

2024Nov28

FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

2024Nov25

CutString96_NumberBefore and After

Cuts the number found before our search word by going back certain number of ...

2024Nov24

VBInstr_Any

Returns the index where any of the words from AnStrSearchFor found in SearchIn ...

2024Nov17

VBInstr_Any

Search for string inside another, with ability to have multiple strings to ...

2024Nov15

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

1 2 ...6 7