Search results 177

Sorted from new to old.

LXFormat

Formats a number found at end of string to have additional leading zeros to ...

2023Jun30

MapPath_SafeComma

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

2023May19

NumberEnding

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

2023May3

DB Functions (By AI)

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

2023Apr23

WordPress - Excel functions (AI)

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

2023Apr22

EmailSend_Outlook

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

2023Apr5

Progress in two nested loops

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

2023Mar7

Range_Add_or_Subtract

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

2023Feb18

Filename_Clean

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

2023Jan11

Cell_Add_or_Subtract

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

2022Sep1

AddDatabar_ConditionalFormatting

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

2022Aug22

LastRow_Remove

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

2022Aug16

Shape_Select_or_CreateThenSelect

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

2022Jul21

Range2ANStr

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

2022Jul19

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

OST Outlook file location

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

2022May12

1 2 ...4 ...11 12