PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

End ( xlDown )

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

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. ...

bootstrap 5 Spacelab Dark

A Bootstrap 5 css and scss, Spacelab, dark after modified. Not a toggle, just ...

BS5-SpaceLab.zip

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

Fix Excel Issue

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