Search results 83

Sorted from new to old.
Card image
CountColumnCells_Unique

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

Card image
CountNumbers_inString

Returns how many numbers found inside a text

Card image
CountRowCells

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

Card image
CountColumnCells_2Criteria

Counts how many cells matching 2 criterias. Just like

Card image
MatchIf2Up

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

Card image
UniqueRandomID in SQL

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

Card image
Grandchildren files and count

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

Card image
PrCal_Add_Sort

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

Card image
UserChanged_Log4

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

Card image
SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-01-02: Adding ability to ...

Card image
Latest records date and count

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

Card image
BusinessDateDiff

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

Card image
BusinessDateAdd

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

Card image
Column1Range

Return a range of cells in column where ... Return Range Ignore header ...

Card image
End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Card image
Excel user name

Get application user name or change it Originally from