Search results 947

Sorted from new to old.

BooleanCount

Counts how many values are True (or anything) in an array of boolean values ...

2022Apr22

DateDiff_En

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

2022Mar3

Frm5Textbox

Shows a text in textbox as separate window Caller can modify size of textbox, ...

2022Feb22

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

OpenAnyFile

Finally, can have one command to open any file using its default associated app ...

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

Old cell value

Nice solution to read value in cell AFTER changed. Needed to have that feature ...

2021Dec30

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

A is for Alpha

Military way to communicate letters in audio, for me I learned not all required, ...

2021Dec6

1 2 ...20 ...59 60