Search results 60

Sorted from new to old.
Card image
ANmaSum_4IFs

Applies SumIFs for 4 columns, same sheet, same workbook Another function to do ...

Card image
SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

Card image
CountColumnCells_Unique

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

Card image
CutString96_NumberX

Extract a full number from string block having 1 or more full numbers. Like ...

Card image
ANstr_Column

Reads and concatenate the full HTML or non-HTML of column (ColumnID) from HTML ...

Card image
Concatenate_HTMLColumn

Build a string from a certain column in html table (using < table, < tr, and < ...

Card image
Just learnt that now

Looks like we cannot have filename (having no extension) and folder in same ...

Card image
EdgarCIK

Search for company long name in Edgar and returns its CIK Using SEC.gov site ...

Card image
Gototop + Circular scroll progress

JS icon to show progress of scroll in webpage having button to go back to top. ...

Card image
RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

Card image
PivotTable_ShowHideItems

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

Card image
PivotTable_ShowHideBlankItems

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

Card image
ANmaPivotTable_Clear

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

Card image
Modal form open Workbook

Do not open workbook from userform after .show

Card image
List_of_Names + DeleteNames

List names in a certain workbook into sheet. And Deletes those names. You may ...

Card image
Convert_Dash_to_Zero

Convert cells with dashes to zeros. Quick code needed to reset sheet copied ...