Search results 77

Sorted from new to old.

IsError_Range

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

2021Dec30

Subtotal_Indirects

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

2021Nov26

CSVs2Sheets

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

2021Oct5

Highlight row of current month

Highlight row in Excel if it is within current month This is another version ...

2021Sep2

Morse code functions

Convert text or single character to and from Morse code. TexttoMorse, ...

2021Jun13

Logging use of executable in Windows

Log the use of .exe, .lnk, .pif, .bat, and .com files on your computer. All it ...

2021Jun13

Excel crashes when File > Print

During generating Print Preview, Excel crashes. Applies to some files, not all, ...

2021Mar6

Generate_PowerPoint

Creates PowerPoint slideshow file from Excel range(s) with slide per sheet (or ...

2020Dec22

ConcaUFO_RowsfromSheets

Imports rows from multiple sheets of a workbook into final sheet along with ...

2020Nov11

DeleteOtherSheets

Deletes all sheets in a workbook keeping only one

2020Apr3

Excel sheet textbox

Found a strange behavior for Excel sheet textboxes. Textbox in Excel sheet, ...

2020Feb22

Shortcut website

Create a shortcut to website to open using Internet Explorer in 'InPrivate' ...

2020Jan22

FilterSheet_1By1 + FilterSheet_Clear

Sets Autofilter in a sheet, and another function to clear Autofilter ...

2020Jan3

ANmaDB functions

Database functions, commonly used in my systems. Should be working for each ...

2019Apr14

Frm9 - Select workbook (or workbook/worksheet)

Gives your user ability to select a workbook from list of open workbooks within ...

2019Apr3

SheetAdd_ANmar

Adds a sheet to a workbook, after checking if workbook is open Checks if ...

2019Apr1

1 2 3 4 5