Search results 25

Sorted from new to old.

FirstDuplicatedItem

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

Apr18

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

VBInstr_SpaceFriends_BetweenHTMLTags

Searches for string inside string with multiple possibilities, returns ...

Mar13

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

Mar12

ANmaSafeDeleteFile

Deletes file safely without warnings or error messages. Tries to delete it at ...

Mar10

CutString_ANmaRules

Extract certain text from another text based on Rules defined, like extracting ...

Feb26

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

ANStr_RemoveDuplicates

Removes duplication in ANStr separated by a separator.

2024Jul13

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

2024Feb18

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

1 2