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.

Open an Excel workbook on your PC. You can now close the VBA window and go back to your Excel sheet. Pick a cell, type ...

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

Compile error in hidden module is an error message that might pop up for some MS Word and Excel users. Check out some easy steps to fix it.

Right now it only works in a formular but i really need to be a function with input / output in a module so i can call it from the whole project.

Compile error in hidden module in Excel or Word occurs when the code is incompatible with the version or architecture of this application.

For instance, the excel file you are trying to open is targeting a 32-bit application, but you are trying to open it in a 64-bit version. Microsoft Excel VBA Compile in hidden module error ...