Category: VBA
Get the user name in an Excel cell with a formula or VBA macro
If you want to get the Windows user name in an Excel cell, there are at least two ways to do that. By using an Excel formula to return the username, you will get dynamic results depending on who will open the file. Otherwise, you can return the same with VBA and a simple Excel…
How to run Excel macro on file opening
Here is how to run Excel macro automatically every time you open the file in a few easy steps.
Excel shortcut for Paste Special Values
Here is a simple solution for a handy shortcut to paste copied Excel data as values. The idea is that you add a simple VBA code to your Personal.xsb file and create a shortcut that you like.
How to calculate today’s date in Excel, VBA code in Excel, DAX, Power Query, R, PowerShell, CMD and SQL
No matter what kind of tool you use need to get today’s date remains. Here is how to do that in eight different environments.
How to fix it: Excel 2016 restarting immediately after opening xlsm file
This kind of problem when Excel crashes do not happen very often, but with no recovery options it can make you feel frustrated. Here is the solution that helped me and I hope you too.