Search results 236

Sorted from new to old.

LstCustomSelection_Refresh

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

2022Aug31

ANmaBatchCreate + ANmaBatchRun

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

2022Aug25

AddDatabar_ConditionalFormatting

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

2022Aug22

SettingNameAlreadyFound

Searches for a setting value in set of Settings, in Excel spreadsheet using ...

2022Aug18

Shape_Select_or_CreateThenSelect

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

2022Jul21

Range2ANStr

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

2022Jul19

Export2CSV

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

2022May16

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

Win10 Pin shortcuts

Multiple shortcuts to same app in Windows 10 taskbar

2022Apr25

Hide SQL table

A simple easy way to hide tables in SQL Server

2022Apr23

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

ShapeName clicked

Simple command to know which object (shape) the user clicked When you assign a ...

2022Feb4

GetGroupMembers

List All the Members of a Group Needs GroupNames text file having list of ...

2022Feb1

IsError_Range

Checks if range has at least one error in a range of cells Fast, and simple

2021Dec30

RowList_Matching

Returns list of rows numbers having cells matching text in a column. Passing ...

2021Dec27

1 2 ...5 ...14 15