Search results 235

Sorted from new to old.

DB Connection Drivers Test

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

Mar12

HTMLTableRow_LastRowWithData

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

Feb19

PrevWeekday

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

Feb1

TrimLines

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

Jan31

ANmaRemoveDuplicates2

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

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

FilesIn2 - sorted files

List of files, sorted by name, size or modified date ascending or descending. ...

2024Nov25

ArraySort_3Cols

Returns the Array of 3 cols after sorting it

2024Nov18

SSL/TLS certificate add/update

Always found myself struggling when applying security to websites for the past ...

2024Nov7

Sheet_RowID_Generate + _LastUsed

Generate random unique ID in a column as IDyyyymmRRRR And the second function ...

2024Nov3

Match4_4thNot0

Searches for three cells in three columns then checks for 4th column if not ...

2024Nov1

HTMLTable_NoOfColumns

Gets no of columns in an HTML table. It actually gets the maximum number of ...

2024Oct26

CleanArray_2Dim

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

2024Oct24

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

Get boot time

Get the last time Windows 10 was started. Needed this quickly for research.

2024Sep6

ANmaRead_1stFile

Returns information about first file name found after sorting matching files in ...

2024Aug11

1 2 ...14 15