Search results 107

Card image cap
Protecting VBA code

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

Card image cap
ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

Card image cap
ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

Card image cap
Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

Card image cap
AutoSaveOn

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

Card image cap
Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

Card image cap
Too large procedures

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

Card image cap
UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

Card image cap
Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

Card image cap
COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

Card image cap
Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

Card image cap
NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...