Hi Artur ,

I would like to run this macro on an excel file that I have :

Dim lr As Long

lr = Cells(Rows.Count, 1).End(xlUp).Row

Range("G2:G" & lr).formula = "=COUNTIF(F:F,F2)"

how can I see the result on the same file im running the macro on ? or how can I make it run actually ?

Hi Nawras,

In order to run it on you excel file, you need to replicate the same scenario but using your excel file.

Just download the zip folder, extract it and replace the excel file with your excel file.

Make sure that you change the Module and Procedure names and use those that are in your excel file.

If you get any issues, you can send me your excel file then I can put all together.

Don't forget to change your Excel extension from .xlsx to .xlsm.

I want to run the macro through Run Macro AC , I am not sure how does this AC work , I wrote the code in it and chose the excel file ( the macro is not embedded in the excel because I run it on different excel files that I create) .

what does actually happen when the Run Macro AC ends ?

Thanks for your help 🙂

Hi,

Even if the script is not in the excel file on which you want to run you still need to have a .xlsm from where the commands will pass to your desired file.

You can select a "Custom macro" option but you still need a .xlsm excel sheet and the procedure name.

I am attaching a sample where a custom script has been used, extract the files, upload the wizard to your environment, change the ExcelPath variable and make sure that this works on your end.Afterwards, you can modify it with your custom code.

Got it , it worked !

Thank you alot

Hello, 

is there any issue with “Run Macro” AC in version 21.10.5.5?

running this returns “CODE_ERROR” now ..