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

CopyDynamicRangeValue

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

Bootstrap 5 color toggle

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

BS5-Dark-Light-Modes.zip

Zoomed iframe

Show iframe zoomed or in scale Thanks to

Autofit height iframe

iframe with animated gif to show while loading content, when iframe is fully ...

Range22DimArray

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

ForegroundColor

Returns white (RGB 255,255,255) or Black (RGB 0,0,0) based on background color ...

DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...