What is the difference between .Text, .Value and .Value2
November 15, 2023There are three ways to use VBA in Excel to extract the value from a cell using the Range object… Read more
Tag: vba
Highlight selected row in Excel
Nov 10, 2022Especially with large datasets, it can be an advantage to give the activated row (and possibly column) a different background color… Read more
Rainfall radar in Excel with JSON
November 2, 2021The possibilities in Excel are virtually unlimited. You can even create your own rainfall radar and process the data in a… Read more
Add macro to context menu
October 11, 2021If you often use a certain macro, it can be useful to add it to the… Read more
Remove password protection from Excel file
13 May 2021Excel files have the option to provide them with password protection. I use it once in a while. For example to… Read more