Search results 60

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

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

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

WinImage.dll

An old DLL library enables reading and writing to floppy disks (and/or images) ...

2020Jul18

FolderSize_Swift

Gets total of folder size in bytes. With some tweaks, you can modify it to use ...

2020Apr20

Delete_Unwanted_Rows

Delete rows in a different way I used to delete rows by looping through those ...

2020Apr14

Excel-VBA Limits

These are some limits I found during my work in Excel-VBA For more of Excel ...

2020Feb5

1 2 3 4