Search results 580

Sorted from new to old.

Dropdown button commands

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

2022Oct12

RunOnTime

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

2022Sep29

ANmaRemoveDuplicates

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

2022Sep25

ANmAdvancedFilter

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

2022Sep15

HyperlinkFunction

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

2022Aug24

AddDatabar_ConditionalFormatting

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

2022Aug22

FoundinList

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

2022Aug12

Range2ANStr

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

2022Jul19

RemoveDuplicates

Removes duplicated items from a 1-dim array into new array, does not modify ...

2022Jul7

Protecting VBA code

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

2022Jul6

SQL Related posts

Steps to create related posts query in SQL. Index, catalog, matching posts for ...

2022Jul6

ANmaSQL_UpdateDateStatement

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

2022Jul4

DBTable2CSV

Exports table into CSV from ASP Classic function.

2022May31

Img not found - Temp pic

Showing image not found if img src image is missing

2022May27

ASP Classic Page Cache

Set page to cache at certain time or force cache refresh. Something I found ...

2022May20

Export2CSV

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

2022May16

1 2 ...9 ...36 37