Search results 28

Sorted from new to old.
Card image
DBTableCol_Array

Reads 1 column from SQL DB table and return as 1-dimension array oConn object ...

Card image
ANmaRemoveMultiSpace

Removes multiple spaces from within string, those are up to 16 spaces that ...

Card image
HTMLTableRow_LastRowWithData

Retunes the row from bottom that has data (not blank or hidden)

Card image
ANmaRemoveBlanks_1Col

Remove blank cells from 1 column

Card image
CleanArray_2Dim

Cleans an array of 2 dimensions from blank in 1st column. Similar to

Card image
Choose10

Choosing a return value based on an ID. Since we have Choose2, Choose3 and ...

Card image
HTMLTable_FullRow_NonBlanks

Returns all numeric values in row separated by Sepa Only cells that are not ...

Card image
ANStr_Add10IfNotBlank_NorNA

Concatenate string into one, if not blank and not N/A It looked stupid for me ...

Card image
IfString_StartsWith_AndOr_EndsWith

Checks if String starts with certain char and ends with certain char Or one of ...

Card image
RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Card image
ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

Card image
Column1Range

Return range of cells in column having data where, ignoring header cell and ...

Card image
SqlExec

Runs SQL Command that needs no return This is primarily useful for CREATE, ...

Card image
CleanArray

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

Card image
MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

Card image
TeeOpen_ProtectTee + TeeOpen_UnprotectTee

Protect or unprotect a workbook (already open) remotely from another workbook ...