Excel – Create and add a custom Ribbon Tab (Menu)
Adding a custom tab into a specific Office document (2007+ documents) can be very useful if we need to transport, with the document, custom VBA/macro codes. Read More …
Category: Excel
Excel – If cell is not blank (Formula & VBA)
In this article we will see how we can identify, and operate in different ways, blank cells directly in formulas and VBA code. Read More …
Excel – Remove Everything But Duplicate Rows
In Excel, we all know that, there will be a moment in which we need the opposite the people usually need on usual Excel worksheets: this is the case of searching and filtering, from a dataset, only duplicates values, removing the unique ones. Read More …
Excel – Allow Certain Users to Edit Cells Range
Excel offers you an ability to assign user-level permissions to different areas on a protected spreadsheet. You can specify which users (usually local or Active Directory ones) can edit a particular range while the spreadsheet is protected. Read More …