Search results 42

Sorted from new to old.

VBInstr_Any

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

Fri 5AM

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

Nov8

ANmAddressRefStyle

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

Sep23

Choose2

Returns a value based on an ID. If ID is 1, return 1st value, If ID is 2, ...

Aug20

ANmaSearch_SpaceFriends and LeftSpaceFriends

Searches for string inside string covering multiple possibilities for space ...

Jul30

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

Jul23

ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

Jul7

ANmaRemoveNestedTags

Remove tags that are identical and nested inside each other in an HTML document, ...

Feb4

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

Jan8

HTMLPadding_or_Margin

Finds the padding or margin from a style statement for an HTML tag. Passing ...

Jan5

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

NumberDigitImage

Creates list of images to represents a number. Basically multiple < img > tags ...

2023May15

ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

2023Mar20

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25

1 2 3