Search results 222

Sorted from new to old.
Card image
MapPath_SafeComma

MapPath version expecting comma in filename or folder. Just because we might ...

Card image
NumberEnding

Add st, nd, rd or th to end of number, can be used for dates also

Card image
ArrSort_5Arr and ArrSort_7Arr

2 functions to sort 5 Arrays or 7 Arrays respectively.

Card image
DB Functions (By AI)

3 functions to add or update data to DB and Read from DB. These were also ...

Card image
WordPress - Excel functions (AI)

3 functions to download posts, adds new post and to upload and set featured ...

Card image
EmailSend_Outlook

Send email using Outlook object with attachments With AI-generated post image. ...

Card image
ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

Card image
Progress in two nested loops

Formula to show progress to end user from inside two loops. More like an ...

Card image
Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

Card image
Filename_Clean

Returns cleaned file name of invalid characters. Needs to be modified if used ...

Card image
Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

Card image
Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

Card image
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

Card image
LastRow_Remove

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

Card image
Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

Card image
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...