Search results 775

Sorted from new to old.
Card image
DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

Card image
DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

Card image
Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

Card image
CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

Card image
Range_SaveAsImage

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

Card image
CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

Card image
Too large procedures

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

Card image
UISetup + UIRestore

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

Card image
Fill down

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

Card image
COUNTIFS as Rank

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

Card image
IsError_Range

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

Card image
RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

Card image
InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

Card image
Tabindex in multipage

Tabindex and forcing focus to show in textbox if we have multipage control. ...

Card image
Subtotal_Indirects

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

Card image
CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...