Search results 70

  2. Search results
  3. worksheet
Card image cap
Range22DimArray

Imports a range into 2-dimension array. Returns the array, providing range, ...

May11
Card image cap
ScanFolder

Scans folder and its all subfolders (2 levels only) for files then put file ...

Apr7
Card image cap
ScrapeURL_ToSheet

Reads content of Page from URL to a sheet. This was made specially for certain ...

Apr4
Card image cap
ImportCSVs - 1st AI Code

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

Mar20
Card image cap
ANStr2Range

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

2022Nov11
Card image cap
ANmaRemoveDuplicates

Removes duplication in table in 1 or more columns. Will work in sheet, ...

2022Sep25
Card image cap
ANmAdvancedFilter

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

2022Sep15
Card image cap
AddDatabar_ConditionalFormatting

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

2022Aug22
Card image cap
LastRow_Remove

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

2022Aug16
Card image cap
Range2ANStr

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

2022Jul19
Card image cap
ANmaSQL_UpdateDateStatement

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

2022Jul4
Card image cap
ANmaSQL_InsertStatement

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

2022Jul3