Search results 89

Card image cap
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

Card image cap
LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

Card image cap
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

Card image cap
Export2CSV

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

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
Fill down

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

Card image cap
Old cell value

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

Card image cap
IsError_Range

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

Card image cap
RowList_Matching

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

Card image cap
GetColumnIndex

Returns Id of column (Column Index) from a cell. Similar to GetColumnName, this ...

Card image cap
Subtotal_Indirects

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

Card image cap
CleanArray

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