Search results 197

Sorted from new to old.

AddressReferenceStyle

Change Address style from R1C1 to A1 or from A1 to R1C1. Something I needed ...

2023Nov1

BusinessDateAdd

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

2023Oct11

CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

2023Aug10

Bootstrap 5 color toggle

Working toggle button to switch between light and dark color modes in Bootstrap ...

2023Aug6

Zoomed iframe

Show iframe zoomed or in scale Thanks to

2023Aug4

Frm3

Browser window in a userform Just add Frm3 and call Frm3.Frm3_OpenWeb passing ...

2023Jul30

FrmRename

Userform to switch names of two files. Basically renaming two files with each ...

2023Jul7

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

1 2 ...5 ...12 13