Min_No0s

Getting the minimum number from an array excluding zeros.

ListBox bug with TabIndex

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

ANStrSort3

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

HTMLPadding_or_Margin

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

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

LXFormat

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

SubZero

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

NumberDigitImage

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

NumberDigitImage.zip

Convert_Dash_to_Zero

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

MultiTrim

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

Max + Min

Calculate maximum of array of numbers or Minimum of array of numbers Also, ...

HeadingZeros Remove and Add

Adds or remove zeros at start of string Used to clear heading zeros from ...