Search results 23

Sorted from new to old.

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

ConditionalFormatting_Clear

Clears all conditional formatting in a range in a sheet in a workbook.

2024Nov10

RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). The pattern ...

2024Nov10

CleanArray_2Dim

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

2024Oct24

DecimalPlaces

Returns how many decimal places the number have

2024Jul24

Min_No0s

Getting the minimum number from an array excluding zeros. Edit 2025-03-11: ...

2024Jun5

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

2024Feb20

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

2024Feb14

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

2024Jan9

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

NumberDigitImage

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

2023May15

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Dropdown button commands

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

2022Oct12

RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

2021May29

1 2