Search results 47

Sorted from new to old.

VLookup_HTML

Does a search in 1st column (< td tag) in an HTML table (< table tag), and ...

2024Jan26

ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

2023Dec22

MathInsideANString

Perform math on numbers inside list of numbers in format of ANString. ...

2023Nov20

Timeline css

CSS Timeline, simple, easy, nice piece from bootsnipp From

2023Nov14

HTML2Str

Special version to convert HTML to string. Uses RemoveHTML, then after that it ...

2023Nov5

Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...

2023Mar14

Filename_Clean

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

2023Jan11

OutlookFolder_DuplicatesRemove

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

2023Jan1

OutlookFolder_DuplicatesCount

Counts emails with 1 or more duplicates in active folder in Outlook. Still not ...

2022Dec31

MultiTrim

Trims leading and trailing tabs, spaces and Enters Code has lines to work in ...

2022Dec3

ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

2022Sep25

Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

CleanArray

Cleans array of unwanted items This usually needed after you merge two arrays, ...

2021Sep22

TrimEnters

SQL Function to remove repeated Enters from a string in SQL Chr(13) + Chr(10)

2020Sep19

Add2Column

Quickly adds value to certain column in Excel sheet As usual, you can define ...

2020Jan3

1 2 3