Search results 16

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

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

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

RandomHelloACM

Generate random using web service into ASP variable. With help of PHP, we now ...

2018May13

Floor

Rounding a number to nearest integer closest to zero.
Equivalent to Excel ...

2018Apr25