Search results 60

Sorted from new to old.

Pagebreak and Pagebreak preview

When setting the location of pagebreak, you need to have that sheet view set to ...

2025Nov11

ANStrVLookup

behaves as vlookup to return item from 2-dim ANStr Can choose which column, ...

2025Jun14

MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

2025May10

VBInstr_Rev_Any

Finds first match of string inside another in reverse order. From right to left ...

2025Apr11

ANmAddress_Dimensions

Detects how many dimensions an address has, This is what I call it dimensions ...

2024Nov8

GetPapa + GetSon with variances

Gets the parent folder full name from a path Also Gets the son of a full path. ...

2024Oct26

MaxOfArray

Gets the maximum number from an array. Like

2024Oct24

CutString12

Cuts string between two numbers that found inside string. Like extract the ...

2024Aug22

FindZipFile_WShell

Finds the first zip in a folder matching wild cards mask using WScript.Shell ...

2024Aug2

FindImg_WShell

Finds the first image in a folder matching wild cards mask using WScript.Shell ...

2024Jul31

Center Userform

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

2024Jul23

IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

2024Jul18

ANmaSearch_QuoteFriends

Searches for string inside string with double-quote possibility If single ...

2024Jul13

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

2024May16

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

1 2 3 4