Search results 762

Sorted from new to old.

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

DynamicFill

Fills in more rows at end of a range Used to add more rows at end to have all ...

2022Mar11

DateDiff_En

Calculates the differences of date (against NOW) and return in English ...

2022Mar3

Frm56Msg

A message box with checkbox, 1 command button says ok only. Caller can set ...

2022Mar3

CleanFilename

Cleans file name from invalid unexpected characters that Windows refuses.

2022Feb22

Range_SaveAsImage

Exports range to an image, something we wanted to be able to do for a while now. ...

2022Feb16

CopyFiles

Copies files from list of files into a folder. Uses list of files with ...

2022Feb3

Too large procedures

No longer than 2.9k lines in a sub Oops. Baaaaad coding habits This also ...

2022Jan29

UISetup + UIRestore

Simple way to freeze UI in Excel-VBA then restore it after complete in standard ...

2022Jan28

Fill down

Fill down series in Excel. NotReadyYet! This is a work-in-progress function! ...

2022Jan5

COUNTIFS as Rank

Simplest way to rank among peers. used COUNTIFS in case we need to add more ...

2022Jan1

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

InStr and InStrRev

How to use InStr and InStrRev VB functions It is silly, I know, but I keep ...

2021Dec6

1 2 ...14 ...47 48