Search results 18

Sorted from new to old.

Match5_5thNot0 and Match6_6thNot0

Searches for 4 cells in 4 columns then checks for 5th column to not equal zero ...

Nov13

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

Nov2

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

Nov1

DecimalPlaces

Returns how many decimal places the number have

Jul24

Min_No0s

Getting the minimum number from an array excluding zeros.

Jun5

ListBox bug with TabIndex

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

Apr15

ANStrSort3

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

Feb20

HTMLPadding_or_Margin

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

Jan5

CopyDynamicRangeValue

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

2023Aug10

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

Max + Min

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

2019Dec31

HeadingZeros Remove and Add

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

2019May31

pd

Format a number with total number of digits I used it to format a date as ...

2018Dec29

1 2