Search results 60

Sorted from new to old.

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

Jan20

Grandchildren files and count

Returns list of files in 2 level folders Will not find files as children of ...

Jan11

HMatchIf_Multi

Returns column if an item from list of items was found in a row. Similar to ...

2023Oct30

Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

2023May11

Range2Block

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

2023Mar6

Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12

LastRow_Remove

Removes last row in a table starting certain cell. Creating and using this ...

2022Aug16

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26

Frm6 - ANmaMultiSelect

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

2021Jun23

Row_PixelLocation

Gets the cell row where a certain shape is located by passing shape.Top number ...

2021Feb2

ANStrSort2

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

2020Sep24

Custom Treeview control

A .Net project to create Custom Treeview in ASPX pages, this is a Csharp project

2020Jul18

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 4