Search results 101

Sorted from new to old.

Range2Block

Concatenate all rows found in a range starting A1Cell for Columns_To columns ...

2023Mar6

Filename_Clean

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

2023Jan11

ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

2022Nov11

ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

2022Aug25

Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19

Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

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

InSheet_ChangeImage

Allows users to inserts image into sheet, replacing old one, with ability to ...

2021Feb20

ANStrSort2

Sort list of strings in ascending or descending order using pure VBA, no ...

2020Sep24

RBU - Simple Registry Backup batch

RBU simply means "Registry Back Up" and is a tiny BAT (batch) file that will ...

2020Sep15

Windows-like drop down menu

Classic-Windows-like dropdown menu using CSS and JS, library in zip is build in ...

2020Aug20

CreateList_Matching

Creates list of items found in rows, where these rows match a value in another ...

2020May13

Column2AnString_Unique

Creates list of unique items found in a column, returns string with items ...

2020May6

1 2 3 ...6 7