Be able to use user-defined Power Query functions in Excel formulas
Power Query has a few advantages over VBA for creating user-defined functions for use in Excel formulas:
• Power Query produces shorter code that is faster and easier to write. This is largely thanks to Power Query native supporting tables, lists, and records; having many built-in functions to work with these data types; and supporting first-class functions and higher-order functions, which eliminates repetitive code and grants the programmer more expressive power than VBA.
• The Power Query GUI produces code that is closer to ideal than the VBA code that the Macro Recorder produces. Power Query also shows your recorded steps in a GUI and allows you to delete any step at any point.
• Power Query is focused on data manipulation and calculation. VBA includes the clutter of programmatic spreadsheet editing.
• Power Query can be used in any modern Excel spreadsheet format. VBA cannot be used in XLSX files.
• Power Query is being actively developed. The VBA in Excel is outdated and is largely abandoned.
Please allow us to use user-defined Power Query functions in Excel formulas.