Search results 74

Card image cap
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

Card image cap
SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

Card image cap
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

Card image cap
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

Card image cap
Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

Card image cap
Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

Card image cap
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

Card image cap
AddDatabar_ConditionalFormatting

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

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