Search results 130

Sorted from new to old.

ContainerHTMLTag

Returns HTML tag of the container of certain location inside HTML block. ...

2023Oct21

Total14Round

Round time to Hours:Minutes format regardless of number of days Like in 80:40. ...

2023Aug8

Luhn

Luhn function to return true or false if is valid based on Luhn identification ...

2023Jul25

SubZero

Forces Excel to not convert numbers during moving them across sheets, or ...

2023May23

ANmaInt

Cuts the integer part of a number. Like INT, FIX, or CINT I know we already ...

2023May2

ReadBinaryChunk

Reads certain chunk of a file in binary. Used with large files (like ~7gb ...

2023Apr28

ANmaDate

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

2023Apr27

ReadLastChars

Reads last some characters of a file, needs to see contents of large files that ...

2023Apr20

AskForFolder

Asks user to assign a folder, been looking for something like this for awhile ...

2023Mar23

Progress in two nested loops

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

2023Mar7

Filename_Clean

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

2023Jan11

Dropdown button commands

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

2022Oct12

LstCustomSelection_Refresh

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

2022Aug31

DiskDriveType

Returns drive type as text, like fixed, CD, etc. Can pass either drive letter, ...

2022Aug17

OST Outlook file location

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

2022May12

DynamicFill

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

2022Mar11

1 2 ...4 ...8 9