Search results 14

Sorted from new to old.

Returns reference of a table in Excel workbook. This is because not all tables ...

Jul24

COunts unique cells found in a column. Passing sheetname, workbook name and ...

2024Oct6

Sort range of cells by up to 4 columns. Can use any of these columns, not ...

2024Apr15

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

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

2022Apr26

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

Gets a sheet name by referencing sheet ID or Sheet No This is more likely to ...

2018Aug23

Deletes a sheet from a workbook, checks it is already there first

2018Aug9

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

2018Jul5

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

2018Jul4

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

2018Jul4

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

2018Jul4

Will add hyperlink in a cell to a sheet in same workbook Not Hyperlink ...

2018Jun24

Finds a sheet in a workbook, if no workbook name passed, it will use ...

2018Jun7