gsplit usage

How to use gsplit to split large files into smaller parts to allow to read it. ...

GSplitPDF.zip

PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

FontAwesome Custom icons issue

I faced an issue the past few weeks when trying to add my own icon to ...

XMLRead

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

Can't find Project or Library

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

Fix Excel Issue

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

Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

Img not found - Temp pic

Showing image not found if img src image is missing

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

ExitTool and DoNothing

My way of Exiting tool in case or error, also another sub that basically does ...

DB_Connect

VBA-Excel function to connect to SQL Database server, in addition to ...