How to have Excel convert formula to value using VBA

How to have Excel convert formula to value using VBA

Printing values instead of the formulas themselves can help protect your IP or prevent users from changing them. In this article, we’re going to show you how to have Excel convert formula to value using VBA.   How to have Excel convert formula to value We...
How to compare two rows in Excel using VBA

How to compare two rows in Excel using VBA

Comparing data row by row manually can be a tedious process if done manually. Let us show you how to compare two rows in Excel using VBA and automate this process.   How to compare two rows in Excel using VBA VBA has a built in function called StrComp that can...
How to find named ranges in Excel by highlighting them using VBA

How to find named ranges in Excel by highlighting them using VBA

Named ranges are very useful when creating Excel models. However, it can get pretty hard to track what named range belongs where as your model grows. Highlighting them on your worksheets can help you identify their properties easily. In this article, we’re going...
How to lock a cell in Excel formula using VBA

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 alphabetize Excel tabs using VBA

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

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 hide formulas in Excel using the Protect Sheet feature

How to hide formulas in Excel using the Protect Sheet feature

If you don’t want your users to see or be able to edit your formulas, you can lock, or hide them easily using Excel’s Protect Sheet feature. This allows you to prevent any edits to formulas, or hide them altogether behind an optional password protection....