Search results 95

Sorted from new to old.
Card image
SheetTabColor

Applies certain color to sheet tab in Excel. ColorNumber is Excel ColorIndex. ...

Card image
CopyDynamicRangeValue

Copy values from range to cell. Without using clipboard of course. Here the ...

Card image
ImportCSVs - 1st AI Code

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

Card image
Range_Add_or_Subtract

Adds an amount (or subtract) from a range of cells in one click Similar to

Card image
OutlookFolder_DuplicatesRemove

Removes duplicated emails in an outlook folder. Originally not my work, ...

Card image
OutlookFolder_DuplicatesCount

Counts emails with 1 or more duplicates in active folder in Outlook. Still not ...

Card image
ANStr2Range

Converts a string of items into range, with custom separator. Opposite of

Card image
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns using Excel ...

Card image
Cell_Add_or_Subtract

Adds amount to active cell, or subtract Applies to selected cell in current ...

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
Shape_Select_or_CreateThenSelect

Selects a shape inside sheet to change it, or if not found, it will create it ...

Card image
Range2ANStr

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

Card image
ANmaSQL_UpdateDateStatement

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

Card image
ANmaSQL_InsertStatement

Creates SQL INSERT statements from a table in Excel. Used to be executed to ...

Card image
Export2CSV

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