Search results 70

  2. Search results
  3. book
Card image cap
ImportCSVs - 1st AI Code

Imports multiple CSVs found in a folder into worksheets of active workbook ...

Mon Mar20 8AM
Card image cap
Convert_Dash_to_Zero

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

Tue Mar14 7AM
Card image cap
RunOnTime

Runs a certain macro on certain time. This is not a scheduler, but just simple ...

2022Sep29
Card image cap
ANmAdvancedFilter

Filter table inside Excel the fast way (using advanced filter) into another ...

2022Sep15
Card image cap
HyperlinkFunction

Returns the formula for a hyperlink [=Hyperlink(...) ] to be inserted in a cell. ...

2022Aug24
Card image cap
AddDatabar_ConditionalFormatting

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

2022Aug22
Card image cap
Range2ANStr

Converts sheet range to ANString, can work on any continued range, 1 or 2 ...

2022Jul19
Card image cap
Protecting VBA code

Steps to protect VBA project in Excel, posted here for reference mainly. An ...

2022Jul6
Card image cap
ANmaSQL_UpdateDateStatement

Creates "Update Table " SQL statements to be executed inside SQL to modify ...

2022Jul4
Card image cap
AutoSaveOn

Automatically save workbook (when using OneDrive) on or off This is the VBA ...

2022Feb23
Card image cap
RowList_Matching

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

2021Dec27
Card image cap
Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

2021Aug13