Search results 61

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

Font-Based progress bar

Show progress bar using fonts only. Neat trick to use inside HTML or word ...

Sep29

ANmaSearch_OrFriends

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

Jul30

Center Userform

Looks like forcing a Userform to be in center of an application is not as easy ...

Jul23

ANmaSearch_AmpFriends

Searches for string inside string with multiple possibilities if the char & ...

Jul7

MatchIf6

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

May31

ANmaSearch_ApostropheFriends

Searches for string inside string with apostrophe variations conversion

May27

CopyFiles Excel-Macro

Simple macro to make sure we have a copy of all files in a folder found in ...

Mar12

Int function in ASP Classic (cint vs fix)

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

Feb6

VBInstrRev

Similar to VBInstr, but this one does it in reverse, which is instrrev() ...

Jan24

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

Jan11

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

VBHTMLInstr

Searches for string in readable text from HTMLBlock. So it will not find what ...

2023Dec3

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

1 2 3 4