Search results 59

Sorted from new to old.

Hack VBE password in .xlsm

Remove VBE project password protection off of xlsm. This is screenshot on how ...

2025Dec30

JSon_Read_aText

Reads all json files generated by aText Sync command (screenshots) from certain ...

2025Jul27

MatchIf7

Finds the row of 7 columns matching 7 values with options of < > <> and <= ...

2025May2

NumberBeforeString

Returns number if found before certain word in larger string. This can be used ...

2025Apr10

RangeValues

Returns values of all cells in range into 1 string Only non-blank values ...

2024Jan25

PivotTable_ShowHideBlankItems

Shows or hides an item or items in a PivotTable filter field. Passing ...

2024Jan22

Times_inHours

Calculate the total number of hours between two times and return in format ...

2023Jul20

SettingNameAlreadyFound

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

2022Aug18

DynamicFill

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

2022Mar11

ServerXMLHTTP stream

Using ServerXMLHTTP object to show (stream or download) and image , or any ...

2021Aug3

DegreesToXY

Calculates X, Y of position on a Circle or ellipse. Pass the center X, Y of ...

2021Jun13

Regular expressions (Notepad++)

How to do regular expressions in Notepad ++ search and/or replace Helpful when ...

2021Mar10

ClearHistory10_20

Delete folders named in format [PDFs-2020-12-05] in certain folder along with ...

2020Dec5

ConcaUFO_RowsfromSheets

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

2020Nov11

ListBox_Excel_Sort

Sort items in Fm20 Listbox using Excel spreadsheet Sort function. Can decide ...

2020Sep21

Toggle navbar with Slide Down Animation

TOggle Navbar to show, login form, another list of links, search bar, or ...

2020Jul30

1 2 3 4