Search results 21

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

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

Aug2

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

Jul29

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

Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Mar14

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

NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23

Max + Min

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

2019Dec31

1 2