Search results 16

  2. Search results
  3. exclude zero
Sorted from new to old.
Card image cap
ANstr_Column

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

Jul29
Card image cap
Min_No0s

Getting the minimum number from an array excluding zeros.

Jun5
Card image cap
ListBox bug with TabIndex

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

Apr15
Card image cap
Concatenate_HTMLColumn

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

Mar14
Card image cap
ANStrSort3

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

Feb20
Card image cap
HTMLPadding_or_Margin

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

Jan5
Card image cap
CopyDynamicRangeValue

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

2023Aug10
Card image cap
LXFormat

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

2023Jun30
Card image cap
SubZero

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

2023May23
Card image cap
Convert_Dash_to_Zero

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

2023Mar14
Card image cap
NMRRank_v2021

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

2021Sep23
Card image cap
Max + Min

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

2019Dec31
Card image cap
HeadingZeros Remove and Add

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

2019May31
Card image cap
pd

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

2018Dec29
Card image cap
RandomHelloACM

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

2018May13
Card image cap
Floor

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

2018Apr25