Search results 60

Sorted from new to old.

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

Export2CSV

Exports a sheet into CSV file Dynamically finds number of rows/columns and ...

2022May16

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

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

1 2 3 4