Search results 43

Sorted from new to old.

Hack VBE password in .xlsm

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

2025Dec30

Calculation_StaleValues

Show Stale function formats or hide Excel recently started to show cells with ...

2025Jun30

Outlook data files

Custom default location for Outlook data files. Tell Outlook to always store ...

2025Jun18

ListBox_Read and ListBox_Save

Reads or saves to a certain column in multi-column listbox in VBA Userform Can ...

2025Mar11

Excel 2408 bug

Serious bug in Office update that was pushed Aug 26th. At least from Excel ...

2024Sep10

ANmaSearch_OrFriends

Search for one of items in SearchFor_ListOfFriends inside SearchIn and return ...

2024Jul30

Daily folder

Create daily folder in specific location automatically. I used to have .bat ...

2024Jul28

CalculateQuarterText

Returns the text of quarter (3Q2024 or 1Q2017) with offset of the passed ...

2024Jun10

Q_NoOfdays

Calculates number of days for certain quarter, starting from given quarter with ...

2024Jun9

Random Number in SQL

Generate Random number inside SQL using timestamp (GetDate function) One of ...

2024Jan30

ReadFileBytes

Reads bytes from file using FSO, Number of bytes can be decided as well as ...

2024Jan15

Webfont generater

Online tool. Generate web font to be used in websites. When trying to fix ...

2023Nov27

End ( xlDown )

A bug found because of using End(xlDown) Please stop using Range("A1"). ...

2023Aug28

Enable Blocked Macros in O365 from OneDrive

Recent Microsoft 365 Excel blocked macros from running when they are in ...

2023Jul10

Excel user name

Get application user name or change it Originally from

2023Jun14

Detailed errors - Web.config

Show detailed error using Web.config Was always struggling with the exact ...

2023May25

1 2 3