CutString9

Cuts from CutFrom starting from any of items found from ...

CutString7

Cuts right part of a string starting from certain occurrence of a separator ...

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

ReNumber_IDColumn_inTable

Reset numbers in ID column, with help from AI. The StoredProcedure will move ...

XMLRead

Returns array of values by an XML expression from XML file. Xmlfilepath is the ...

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-01-02: Adding ability to ...

Can't find Project or Library

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

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Enable Includes in ASP Classic

Enable relative paths for ASP Classic includes to work. New servers do not ...

Bootstrap 5 color toggle

Working toggle button to switch between light and dark color modes in Bootstrap ...

BS5-Dark-Light-Modes.zip

O365 Blocked Macros

Recent Microsoft 365 Excel blocked macros from running when they are in ...