Search results 56

Sorted from new to old.

VBA/Excel Registry hacks

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

Mar12

Match4_Until

Search 4 columns with a stop. Tell the function to stop searching after certain ...

2024Nov22

RegExPatternMatch

Checks string against pattern using RegEx (VBScript.RegExp). The pattern ...

2024Nov10

Match3_3rdNot0

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

2024Nov2

HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

2024Oct26

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

ANmAddressSame

Checks if passed addresses are referring to same cell regardless of ...

2024Sep24

Excel 2408 bug

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

2024Sep10

CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

2024Aug2

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

NumberNumberNumber

Finds 3 numbers in a string by ignoring characters between them. ' example ...

2024Mar2

ANStrSort3

Sort list of texts having cell address by cell address as alphanumeric in Asc ...

2024Feb20

ANmaRemoveNestedTags

Remove tags that are identical and nested inside each other in an HTML document, ...

2024Feb4

NumberBeforeString

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

2024Feb1

1 2 3 4