Search results 18

Sorted from new to old.

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

INITool

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

2018Aug25

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

SortArea1

Sorts a range or area by 1 column given its cell address, with options to ...

2018Jul4

Sort1Col

Sorts a column in Excel, easily, with options Expects ... Row 1 is header, ...

2018Jul4

CellRead (SimpleLookup)

Simply reading a value from a specific cell from a sheet from a workbook ...

2018Jun25

1 2