Search results 60

Sorted from new to old.
Card image
PivotTable_ShowHideItems

Show or hide item (or items) in PivotTable for a certain field. Passing ...

Card image
SQL Cross Apply String_Split with XML Path

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

Card image
CutString9

Cuts from CutFrom starting from any of items found from ...

Card image
ANmaPivotTable_Clear

Clears all filters in PivotTable and hide the [blank] item from list, pass ...

Card image
ANStrFind_AndOrAdd

Checks if an item was found in list of items and return 1 if yes, 0 if not ...

Card image
HMatchIf_Multi

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

Card image
End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

Card image
Range2Block

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

Card image
Listbox 1st item [Any]

Allow user to select [Any] as first item in list that will deselect all other ...

Card image
LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

Card image
AddDatabar_ConditionalFormatting

Adds databars conditional formatting to range of cells. Passing column, start ...

Card image
LastRow_Remove

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

Card image
Export2CSV

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

Card image
CreateUniqueList

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

Card image
DynamicFill

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

Card image
RowList_Matching

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