Search results 101

Sorted from new to old.

FormatNumbers_InsideText

Formats all numbers found inside text to certain format. Excluding numbers ...

Mar9

rel nofollow

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

Feb13

Range().top below hidden rows

Hidden rows change the .top of below ranges. It turns out that the range().top ...

Jan13

Textbox_PartialBold

Set part of textbox to bold, starting from StartingChar (like : ) that found in ...

2025Nov13

Pagebreak and Pagebreak preview

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

2025Nov11

MatchIf8

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

2025May10

ImageMSO list

List of all images in ImageMSO used in ribbon as well in other parts of VBA in ...

2025Apr30

VBA/Excel Registry hacks

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

2025Mar12

PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

2025Feb1

CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

2024Oct24

ANmAddressRefStyle

Returns type of the cell address, A1 or R1C1 If multiple cells passed, the ...

2024Sep23

ANmaSearch_SpaceFriends and LeftSpaceFriends

Searches for string inside string covering multiple possibilities for space ...

2024Jul30

CutString97

Cuts part from large string from certain character to certain character with ...

2024Jun5

Triangular coded msg in file

Decodes message from file based on number in each line of text. Attached ...

2024Mar4

ArCaptcha

Captcha in Arabic, great library, will look forward to apply it in my next ...

2024Feb11

gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

2024Feb7

1 2 ...6 7