Search results 60

Sorted from new to old.

Special chars

How to type special characters in keyboard using ALT + keypad numbers I also ...

2021Oct13

Frm6 - ANmaMultiSelect

Give users ability to multi-select from list of items into cells with separator. ...

2021Jun23

ANStrSort2

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

2020Sep24

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

Most recent in Oracle DB

List the most recently added rows based on a date column.

2020Feb7

ANSQLWherein

Creates list of items to be used in ' Where item in (List)' list Mainly adds ...

2020Jan6

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

Add2Column

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

2020Jan3

all_tab_columns

List all columns in all tables for all schemas in oracle db workbench

2019Dec22

Copy formulas

How to copy formulas in VBA code. Learned that the hard way, just like most of ...

2019Oct3

CountArrayCol

Returns the count of array fields, given the dimension, using UBound ...

2019Aug9

Rows 2 Cell

Convert items found in a column matching certain material into list in 1 cell ...

2019Jul30

tAutocomplete

Dropdown list for input box works as Autocomplete Multi-column, themeable ...

2019Jun25

Excel 2010 hyperlink issue fix

An issue I started to see when clicking on a hyperlink in Excel 2010, while I ...

2019Jun16

MatchLastIf

Finds last occurrence of a match in a column Finds the row of last time an ...

2019Jun12

1 2 3 4