Search results 209

Sorted from new to old.

SortArea4

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

SwitchTextinCells

Switch text inside cells with another text. This was needed to correct an bug ...

2024Feb23

Send workbook as email attachment

Retro way to send a workbook you are in as an email. Found it in one of my old ...

2024Feb14

Grandchildren files and count

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

2024Jan11

Frm58

Build needed lines to create string variable having block of HTML. Provide the ...

2023Dec25

ChartLabelsNumberFormat

Apply Number format of 1 decimal to datalabels of specific series in certain ...

2023Dec23

ChartLegendCenter

Put chart legend at center of chart horizontally. Changes left and width only. ...

2023Dec21

PrCal_Add_Sort

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

2023Dec2

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

ReplaceStrings

Replace strings found in list of strings from inside a string, does that make ...

2023Nov11

Subdomain to a folder

Redirects a subdomain into a folder child of main domain, named same as ...

2023Oct17

ANmaFilter3

Filter database into new sheet, by copying certain columns only, not whole ...

2023Oct13

BusinessDateAdd

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

2023Oct11

SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

2023Aug17

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

1 2 ...13 14