Search results 61

Sorted from new to old.

QuarterNumber_FromDate

Returns the number of quarter from a date

2024Jul26

DecimalPlaces

Returns how many decimal places the number have

2024Jul24

ReturnLongestString_Of2

Returns the string that is longer, comparing what is before StrSepa versus ...

2024Jul2

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

2024Jun10

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

Converts two bytes to long

Functions to convert two bytes to a numeric value (long), (both little-endian ...

2024Jan14

Grandchildren files and count

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

2024Jan11

Frequency1

Finds how many a string found inside larger string. Similar to Frequency but ...

2023Dec16

Nearby Color shades

Calculate colors close to input color, a jquery html that will give you 10 ...

2023Nov8

BusinessDateAdd

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

2023Oct11

ANmaDate

Returns date in human format. Which is as follows... Just day name (and time) ...

2023Apr27

Filename_Clean

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

2023Jan11

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

FeeKey + UnFeeKey

Protect Numbers by encoding them into Alphabetic And convert them back ...

2020Nov11

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

1 2 3 4