Search results 173

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
Range_SaveAsImage

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

Card image
ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

Card image
Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

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

Card image
NMRRank_v2021

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

Card image
CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

Card image
merge2Arrays

Merges two 1-dimension arrays and return an array Both should be 1 dimensional ...

Card image
Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

Card image
RandomUniqueID_Sheet

Inserts numeric random unique ID in a column in sheet, specify column, sheet, ...

Card image
Execute exe embedded in Excel

Execute exe file that embed inside Excel sheet This is for experimental, not ...

Card image
HTML5 tags cheatsheet

A simple graphic illustrates the new HTML5 tags and differences against old ones

Card image
Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...