Search results 43

Sorted from new to old.

VBInstr_Occurance

Returns location of text inside another with jump ability for any certain ...

Dec1

VBInstr_Any

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

Nov15

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

1 2 3