Search results 64

Sorted from new to old.

Shapes_HideShow

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

2025Sep30

ANStrVLookupAll

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

2025Jun14

MatchIf8

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

2025May10

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

2025Mar12

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

ANmaCellChar_Superscript_Subscript

Sets certain character inside a cell as superscript or subscript Edit ...

2024Aug11

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

Between_2Chars

Returns if a char was found between two defined characters. Like find if Loss ...

2023Nov22

Thin HTML5 Coming soon Template

Simple, elegant, thin template for Under Contruction site. Found it in my ...

2023Aug19

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

2023Jul24

IfFullWord

Returns True if found as full, False if not found as full Full word means word ...

2023Jul24

Excel user name

Get application user name or change it Originally from

2023Jun14

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

1 2 3 4