Learn how to identify formula cells the easy way using VBA, and then combine VBA and conditional formatting for more permanent identification.

Create a custom formula or function using VBA. Sometimes at work we need to calculate specific metrics, KPIs or just simple percentages, with this principles you can create virtually any calculation ...

Performance becomes an issue with large datasets too. A poorly written macro can bog down Excel and take forever to complete, ...

If the cell contains a formula, the Formula property returns the formula as a string in the same format that would be displayed in the formula bar (including the equal sign). If you set the value or ...

If Excel is not highlighting cells in the formula, enable 'Allow editing directly in cells' and 'Enable fill handle and cell drag-and-drop' in Excel options.

Microsoft Excel allows you to control the program display in various ways, including complete personalisation of the top ribbon. If you're finding the large top ribbon to be troublesome, we'll show ...

Excel has been around for nearly 40 years, and for over 30 of them, formulas and VBA macros have been frustrating users.