Search results 87

Sorted from new to old.

ANString_to_ListSelects

Selects items in listbox from ANStringList. Assuming listbox is multi-select ...

Mon 3PM

DB Connection Drivers Test

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

Mar12

FilesIn2 - sorted files

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

2024Nov25

CountColumnCells_Unique

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

CountNumbers_inString

Returns how many numbers found inside a text

2024Aug1

CountRowCells

Counts how many cells with data in a row, starting from certain column until ...

2024Jun22

CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

2024May1

MatchIf2Up

Search for 2 items in 2 columns starting from last row upword (Starting with ...

2024Apr29

UniqueRandomID in SQL

Generate new Random ID, unique not duplicated in two columns in two tables. ...

2024Feb18

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

2024Jan11

PrCal_Add_Sort

Adds to daily log, two cells, one with date, next with activity that will be ...

2023Dec2

UserChanged_Log4

Adds date to column1 when user enters text in column2. Also, if user remove ...

2023Nov28

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

2023Nov12

Latest records date and count

Find how many items in table, with column DateAdded is the latest DateAdded in ...

2023Nov2

BusinessDateDiff

Number of Business days between two dates. Note that it doesn't take Christmas, ...

2023Oct25

BusinessDateAdd

Counts the number of business days Add or subtract a number of business days ...

2023Oct11

1 2 ...5 6