SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

ListPivotsInfo

List All Pivot Tables and their Sources for a given workbook into sheet. ...

WorkbookSave_ANmar

Saves a workbook handling several scenarios and decide what to do based on each. ...

Bootstrap 5 color toggle

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

BS5-Dark-Light-Modes.zip

Modal form open Workbook

Do not open workbook from userform after .show

Fix Excel Issue

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

IfFoundInList

Checks to see if sStr matches on of the items in Listof, knowing separator, ...

O365 Blocked Macros

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

List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...