-2

I want to run this function

I opened the developer tab in excel, no clue what to do now. I tried creating a "macro button", and then paste the function code in the macro script, but if I press play I get a error related to Private Sub CommandButton1_Click()

and if i try to save the macro, I get this dialog box:

enter image description here

Community
  • 1
rockyraw
  • 157

1 Answers1

-1

Saving Excel files with Functions / macros:

In your message prompt shown in your question, Click No - Excel will take you to the Save As dialog. Enter the file name and remember to select the file type as Excel Macro-Enabled Workbook and click Save.

Running the function:

You have to select any cell (in any of the worksheet within the same file) and type the name of the function =RegexExtract() ( with any of the applicable arguments) to see the function work.

Prasanna
  • 4,174