Search results 192

Sorted from new to old.

ANmaTableAddress

Returns the full name of table with its sheet name to be used in formulas or in ...

Apr26

Shapes_HideShow

Hides or shows multiple shapes in a sheet in Excel, using one line command ...

2025Sep30

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

2025Aug7

Calculation_StaleValues

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

2025Jun30

Outlook data files

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

2025Jun18

ANStrVLookupAll

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

2025Jun14

ANStrVLookup

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

2025Jun14

Header font name and size in VBA

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

2025Jun1

MatchIf8

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

2025May10

MatchIf8Up

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

2025May7

MatchIf7Up

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

2025May3

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

2025May2

ANmaNotMatch

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

2025Apr19

MatchIf4Up

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

2025Apr12

ANmaSum_5IFs

Returns Sum conditionally of 5 columns (SumIFS), in a sheet, certain workbook ...

2025Jan8

CSS2PDF

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

2024Dec20

1 2 ...11 12