Search results 248

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
Add bulk rows to DB Table

Inserts multiple rows into DB table as whole Unlike

Card image
FilesIn_4Array

Returns list of file names along with path, date modified and size in array of ...

Card image
UsedRange

Returns the address of first:Last cells with data in sheet. Like pressing ...

Card image
1st cell of sheet range

Returns the address of first cell in data in range, the very first cell of very ...

Card image
MatchIf8

Searches for 8 cells in 8 columns and returns the row number if all found. Has ...

Card image
MatchIf8Up

Searches for 8 cells in 8 columns and return the row number if all found Just ...

Card image
MatchIf7Up

Returns row number having 7 values in 7 columns if all found. With option of < ...

Card image
MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

Card image
MatchIf4Up

Returns row of matching 4 values in 4 columns searching from bottom to top. ...

Card image
DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

Card image
DB Connection Drivers Test

Test connection to DB using different drivers to see which one works. You may ...

Card image
HTMLTableRow_LastRowWithData

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

Card image
PrevWeekday

Returns date of the previous weekday (Friday, Saturday, Sunday, etc) from ...

Card image
TrimLines

Remove all line breaks from text from a text. Not like

Card image
ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...