Search results 517

Sorted from new to old.

Popup button

List of commands in popup menu. Uses listbox, command button and toggle ...

2022Oct13

ANmaRemoveDuplicates

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

2022Sep25

LstCustomSelection_Refresh

Read list of items from Settings sheet, then Sort, then save, before reading ...

2022Aug31

AddDatabar_ConditionalFormatting

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

2022Aug22

LastRow_Remove

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

2022Aug16

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

Export2CSV

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

2022May16

OST Outlook file location

Outlook OST (and PST) files to be saved in different location Instruction can ...

2022May12

ASPUsers

Show ActiveUsers in webpage using ASP Classic, this also works as an example of ...

2022May4

BrowserSetting

Detect Browser setting (type or other info) using MSWC.browsertype object. Old ...

2022Apr29

DBTables

Returns an array of all table names in a database. needs valid OLE database ...

2022Apr28

CreateUniqueList

Create list of unique items from a column into another column This is similar ...

2022Apr26

1 2 ...10 ...32 33