Search results 92

Sorted from new to old.

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

Column1Range

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

2023Oct7

End ( xlDown )

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

2023Aug28

Excel user name

Get application user name or change it Originally from

2023Jun14

NumberDigitImage

Creates list of images to represents a number. Basically multiple < img > tags ...

2023May15

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

OutlookFolder_DuplicatesCount

Counts emails with 1 or more duplicates in active folder in Outlook. Still not ...

2022Dec31

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

ListBox_SelectionCount

Counts how many items selected in a listbox (multi-selection listbox). Works ...

2022Apr21

1 2 ...5 6