Sessions 59

Sorted from new to old.

NumberBeforeString_HTML2

Cuts a number that would be found 2 words before certain word inside a block ...

Mar20

VBA/Excel Registry hacks

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

Mar12

ANmaSearch_AllWords_FromANStr

Checks if string has all words from ANStr inside Retuns 0 if not found or ...

Jan8

CutString96_NumberBefore and After

Cuts the number found before our search word by going back certain number of ...

2024Nov24

Match3_3rdNot0

Searches for two cells in two columns then checks for 3rd column if not equal ...

2024Nov2

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

2024Nov1

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

ANmaCellChar_Superscript_Subscript

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

2024Aug11

Unblock blocked macros.

Unblock macros in file copied or downloaded from another machine. Excel keeps ...

2024Jul27

ANmAdd_ThenSort_2Columns

Adds values of 2 cells into 2 columns (usually below them). I used these small ...

2024Jun1

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

NumberBeforeString_HTML

Cuts a number that would be found before certain word inside a block string. ...

2024Feb1

FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

2023Dec29

ANmaNumber_Closest2Word

Finds the number between two spaces that is found close to of Word1Location ...

2023Oct24

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

Fix Excel Issue

Fixing Excel broken spreadsheet issue. When working with some large ...

2023Aug1

1 2 3 4