Search results 833

  2. Search results
  3. 4
Sorted from new to old.
Card image
CopyFiles

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

2022Feb3
Card image
Too large procedures

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

2022Jan29
Card image
UISetup + UIRestore

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

2022Jan28
Card image
Fill down

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

2022Jan5
Card image
COUNTIFS as Rank

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

2022Jan1
Card image
IsError_Range

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

2021Dec30
Card image
RowList_Matching

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

2021Dec27
Card image
InStr and InStrRev

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

2021Dec6
Card image
Tabindex in multipage

Tabindex and forcing focus to show in textbox if we have multipage control. ...

2021Dec6
Card image
Subtotal_Indirects

Finds the SUM, COUNT, COUNTA, etc for a range of cells referencing using ...

2021Nov26
Card image
CSVs2Sheets

Import all CSVs found in a folder into sheets, sheet per CSV This was a quick ...

2021Oct5
Card image
fNMRPrgs, Full-form progress bar (frm77)

Show progress bar inside userform, with option to control lots of things. This ...

2021Oct5
Card image
NMRRank_v2021

Ranks a number among set of numbers. This is part of huge tool, we needed to ...

2021Sep23
Card image
PhotoViewer dll

Open image using legacy PhotoViewer from Windows 7 Command line call to use ...

2021Aug25
Card image
tag_add

Add to textbox from listbox (select option) ensure its uniqueness

2021Aug24
Card image
Excel ribbon

Add ribbon menu to certain macro-based workbook to run macro, will only be ...

2021Aug13
12...19...5253