In my recent task, I was required to accept input from the user. One input value was the date of birth and it, of course, must be a date. What I was d...
Do you have a big data on excel sheet and you need to distribute that sheet in multiple sheets, based on some data in a column? This very basic task b...
The SCng function is a VBA function that converts any data type to a single-precision floating-point number ("given that it is a number"). I mostly us...
In a recent task, I was doing filter through VBA on a number column. But that number column had numbers in text format. When I run the VBA script, it ...
In this article, will learn the basics of VBA userforms. I will explain how to create a form in excel, how to use VBA toolbox, how to handle user in...
To save a selected range in excel (say a receipt) as PDF in Excel using VBA use below syntax. The Generic Code Sub SaveRangeAsPDF() Range...
The XLOOKUP function is exclusive to the insider program of office 365. The LOOKUP function has many functionalities that overcome many of the weaknes...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
