Search results 62

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

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

Sep10

HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

Aug7

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

Jul30

ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Jul24

MatchIf6

Searching for row have 6 matches found in 6 different columns, because we had 5, ...

May31

Int function in ASP Classic (cint vs fix)

If you are looking for a function ASP Classic (VBScript) to do what Int() does ...

Feb6

HTML_CleanNumber

Cleans block of string (HTML block) from characters that are not needed Can ...

Jan31

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

Jan15

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

2023Dec19

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

Modal form open Workbook

Do not open workbook from userform after .show

2023Aug3

SubZero

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

2023May23

ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

2023Apr28

1 2 3 4