When editing the macro to define a cell's value for the variable are as follows:
Range (" C7). Select
ActiveCell. FormulaR1C1="=COUNTA (bak1! C [5]) + 1
"I=Range (" c7 ")


In the execution to: I=Range (" c7 ") : error prompt: compile error can't find the path and library

See the answer, need to run the quote, but I why is grey reference point is not in




Help everyone!

CodePudding user response:

Try to change the capital?

I=Range (" C ")

CodePudding user response:

Has nothing to do with the case

CodePudding user response:

Macro is don't change the reference in the process of running, you can point to stop button to stop running, and then try it can add reference.