Search results 61

Sorted from new to old.

rel nofollow

Outside link no follow. html nofollow of rel No more confusion if it is ...

Feb13

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

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

VBInstr_Occurance

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

2024Dec1

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

ANmaSpecialFolders

Returns path for a specific special folder in system Passing the name of that ...

2024Jul26

Center Userform

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

2024Jul23

Protect txt file into word doc with password

Saves txt file as word doc with password. Passing txtfile having full path and ...

2024Jan4

Between_2Chars

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

2023Nov22

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

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

1 2 3 4