Search results 19

Sorted from new to old.

Notes bad for speed

Excel macros performance Adding Notes to cells does affect speed in running ...

Sat 2PM

CopyFields_FromTo

Moves strings within cells into other cells, move or copy. Specific task to ...

2024Apr17

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

2024Jan15

SheetTabColor

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

2023Aug17

CreditCardType

Returns credit card type and whether it is valid or not. Found it in my old ...

2023Jul28

Dynamic iframe height

Adjust iframe height to its content after loading page Needed this trick in ...

2023Apr29

OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

2023Jan1

FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12

Shape_Select_or_CreateThenSelect

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

2022Jul21

Quarter_to_Words

Convert Quarter code to text per special project requirements. A special ...

2020Dec17

File_SettingRead

Reads setting from config file Config file can be passed as argument ...

2020Sep23

Remove_Between2Quotes

Remove any char (or string) found between two quotes in a string This is an ...

2020Mar9

Bootstrap 4 progress bars variables

Enhanced way to use progress bars in Bootstrap 4 Using below variable ...

2020Feb1

ANBSThumbImg + ANBSThumbLink

Creates thumb of an image with or without link to original Use ANBSThumbLink ...

2019Dec1

Parts-File2Page

A classic ASP include file to read txt file of list into a page using bootstrap ...

2019Oct6

HTMLDecode + HTMLEncode

Decode and encode back a string using HTML Technically found online, but ...

2019Aug9

1 2