Search results 338

  2. Search results
  3. this
Sorted from new to old.
Card image
Dropdown button commands

A drop-down of multiple commands in pure VBA. Needed this in a large Excel-VBA ...

2022Oct12
Card image
RunOnTime

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

2022Sep29
Card image
ANmaRemoveDuplicates

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

2022Sep25
Card image
ANmAdvancedFilter

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

2022Sep15
Card image
ANmaBatchCreate + ANmaBatchRun

Creates batch file with certain content, and another function to actually ...

2022Aug25
Card image
HyperlinkFunction

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

2022Aug24
Card image
AddDatabar_ConditionalFormatting

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

2022Aug22
Card image
LastRow_Remove

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

2022Aug16
Card image
FoundinList

Finds a matching item of a number in list of numbers. Returns 1 if found, 0 if ...

2022Aug12
Card image
ArrSort_3Arr

Sort 3 arrays, ascending or descending based on 1st array. Needed for specific ...

2022Jul24
Card image
Shape_Select_or_CreateThenSelect

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

2022Jul21
Card image
Range2ANStr

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

2022Jul19
Card image
Protecting VBA code

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

2022Jul6
Card image
ANmaSQL_UpdateDateStatement

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

2022Jul4
Card image
DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31
Card image
Img not found - Temp pic

Showing image not found if img src image is missing

2022May27
12...7...2122