Search results 60

Sorted from new to old.

Match3_3rdNot0

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

Sat 5AM

Match4_4thNot0

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

Fri 4PM

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

ReadBinaryChunk

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

2023Apr28

Zip_Folder

Zipping content of folder into file. Not tested and Not My Work. Originally ...

2023Mar29

1 2 3 4