Search results 59

Sorted from new to old.
Card image
Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Card image
Install/Uninstall SQLNativeClient DB driver

Install/Uninstall SQL DB driver. SQLNCLI.msi that is needed when you do ...

Card image
PivotTable_ShowHideItems

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

Card image
FontAwesome Custom icons issue

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

Card image
Can't find Project or Library

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

Card image
Fix Excel Issue

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

Card image
Excel user name

Get application user name or change it Originally from

Card image
Detailed errors - Web.config

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

Card image
EmailSend_Outlook

Send email using Outlook object with attachments With AI-generated post image. ...

Card image
MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

Card image
SwapNumbers

Swap two numbers variables without using third variable A trick worth saving ...

Card image
Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

Card image
Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

Card image
AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

Card image
IsError_Range

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