Search results 69

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
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

Card image cap
ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

Card image cap
Convert_Dash_to_Zero

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

Card image cap
Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

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