Search results 83

Sorted from new to old.

Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

Mon 4AM

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

Jun18

ANStrVLookupAll

Retuns list of all matchings after doing vlookups to return item from 2-dim ...

Jun14

ANStrVLookup

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

Jun14

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

Jun1

MatchIf8

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

May10

MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

May7

MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

May3

ANmaNotMatch

Finds first item from RngAddr that is not listed in InRngAddr Returns the item ...

Apr19

MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

Apr12

CSS2PDF

Creates pdf from a css/html document. Looking to test it on next project ...

2024Dec20

VBInstr_Occurance

Returns location of text inside another with jump ability for any certain ...

2024Dec1

Match6_Until

Searches for six values in six columns and return the row number if all found, ...

2024Nov28

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22

VBInstr_Any

Search for string inside another, with ability to have multiple strings to ...

2024Nov15

RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). The pattern ...

2024Nov10

1 2 ...5 6