How to display cell formulas in Excel that contain errors using VBA
Finding cells with errors can be tricky, especially in large workbooks. In this article we’re going to show you how to display cell formulas in Excel that contain errors using VBA. How to display cell formulas in Excel that have errors VBA has predefined types...
How to lock a cell in Excel formula using VBA
Users entering data into the wrong cells or changing existing formulas can make data collection a tedious process. However, you can prevent users from going outside the intended boundaries by disabling certain sections of your workbook. In this article, we’re...
How to un-protect a protected worksheet and vice versa - the VBA method
The common ways of locking or hiding tabs in a workbook can be easy to reverse for many users. Using VBA code to do this is considered a better way to do this, if you are familiar with macros. In this article, we’re going to show you how to...
How to alphabetize Excel tabs using VBA
Keeping your data and calculations on separate tabs is easy for an organized structure, but too many tabs in a workbook can become overwhelming quickly. In this article, we’re going to show you how to alphabetize Excel worksheets in ascending or descending...
How to unhide sheets in Excel with VBA
You might want to hide or unhide certain sheets in a workbook for security reasons and there are several ways you can do this. In this article, we’re going to show you how to unhide sheets in Excel with VBA. How to unhide sheets in Excel Worksheets are...
How to loop through each character within a string
You’ve worked with text data before, used formulas, and created reports, but how do you up your game? Efficiently loop through text data using this simple VBA code to analyze or manipulate strings. Code Sub LoopThroughString() Dim counter As Integer Dim mystring...How to create User Defined Functions (UDF) in SpreadsheetWEB
What is a User Defined Function (UDF)? A user-defined function (UDF) is a function provided by the user of a program or environment, in a context where the usual assumption is that functions are built into the program or environment. Although Microsoft Office Excel...
Developing Mobile Enabled Spreadsheet Tools
While Excel has been a very powerful productivity software, a great majority of businesses have been relying on their employees building powerful tools using this platform. With added capabilities VBA/macros have to offer,...