Search results 22

Sorted from new to old.

Create Tree from 3 columns (Sheet2Tree)

Converts 3 columns in sheet into 3-generation tree using TreeView from Mscomctl. ...

Aug7

Header font name and size in VBA

Looks like it is not easy to change font name, size and style for a header or ...

Jun1

ANmaRemoveDuplicates2

Remove duplicated rows based on 2 columns in a table of any number of columns. ...

2024Dec4

ANmaRemoveDuplicates4

Removes duplicated rows in a table based on 4 duplicated columns. Table can be ...

2024Dec4

Column1Range

Return range of cells in column having data where, ignoring header cell and ...

2023Oct7

ANmaRemoveDuplicates

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

2022Sep25

ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

2022Jul3

GetHeaders

Reads page headers into dictionary object. an example of using Dictionary in ...

2022May5

SumOf_3Filters

Returns sum of certain column in range (or table) in sheet after applying ...

2021Jan29

Add2Column

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

2020Jan3

Bootstrap table by wenzhixin

Working jquery bootstrap table, with pagination, search, sort and column ...

2018Dec29

Wordpress drop-down menu

Add dropdown with User login, logout into menu. This code used to replace "nav. ...

2018Dec18

INITool

INITool Object allows an ASP programmer to work with INI files on the server. ...

2018Aug25

Limit Textarea

Show number of characters in a textarea and limit if it goes greater than ...

2018Jul5

SortArea5

Sort range or area by 5 columns, range can be any number of columns, but the ...

2018Jul5

SortArea3

Sort range or area by 3 columns, range can be any number of columns, but the ...

2018Jul4

1 2