Search results 53

Sorted from new to old.

Notes bad for speed

Excel macros performance Adding Notes to cells does affect speed in running ...

Aug1

Pagebreak and Pagebreak preview

When setting the location of pagebreak, you need to have that sheet view set to ...

2025Nov11

DateAdd_Networkdays

Adds workdays to a date using DateAdd It keeps adding days and checks how many ...

2025Apr6

VBA/Excel Registry hacks

Set of hacks to modify Excel/VBA settings using Windows registry (Regedit) ...

2025Mar12

SettingRead_Bulk

Reads list of passed SettingNames with defined separator from Settings and ...

2024Nov3

DateDiff_Networkdays

Calculates no of workdays between two dates. Option to use international ...

2024Jul25

Microsoft Edge gestures

Microsoft Edge Right-mouse gestures I found that will really save me time ...

2024May27

SettingSave + SettingRead for NumberFormat

Reads or applies certain NumberFormat to cell in settings. Same patterns as ...

2024Apr19

ListBox bug with TabIndex

Setting TabIndex for a listbox to 0 in a Userform will have some issues when ...

2024Apr15

Lazy image loading + placeholder

Setup lazy image loading plus setting placeholder to images. Using

2024Feb10

SQL Cross Apply String_Split with XML Path

SQL select statement to convert list of IDs found in column (from more than row ...

2024Jan20

ANStringListRead_JSON

Reads array into list of ANString, from [ until ] for the giving array name. ...

2024Jan9

SettingRead_JSON

Reads certain value for a certain setting from FullJSONString text block. See ...

2024Jan8

SendEmailMsgv2023

Sending email using Microsoft 365 account. Edit 2024-12-19: Fixing ability to ...

2023Nov12

Can't find Project or Library

Fix for Excel VBA error when library not found. Screenshots should show how to ...

2023Sep1

FilesIn_Array and FoldersIn_Array

Return list of files in a folder back as array. Similar to

2023Aug15

1 2 3 4