Search results 77

Sorted from new to old.

Hack VBE password in .xlsm

Remove VBE project password protection off of xlsm. This is screenshot on how ...

2025Dec30

ShapeDelete

Safely remove certain shape from worksheet

2025Sep30

BoldCodeColor

Bold the first letter and color it based on Bootstrap color theme, info, ...

2025May26

HTML_CountTags

Counts how many certain tag found in an HTML block. like how many tr found in ...

2025May16

String_Fx

Generate repeated text, like String() the function but with ability to repeat ...

2025Apr10

String_S

Generate repeated text, like String() the function but with ability to repeat ...

2025Apr10

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

2025Apr6

NumberBeforeString_HTML2

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

2025Mar20

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

2025Mar11

ConditionalFormatting_ColorARow

Adds conditional formatting to color a row in table based on output of formula ...

2024Nov10

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

ANmAddressSame

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

2024Sep24

ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

2024Jul29

ANmAdd_ThenSort_2Columns

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

2024Jun1

ANmaHTMLTables_Combine2

Combine strings of two HTML tables into string of one table. Edit 2024-10-31: ...

2024May16

1 2 3 4 5