office365,The recording macro generated incorrect code

ZhengQiang Wang 1 Reputation point
2022-03-18T00:40:45.21+00:00
  1. Click the record macro button
  2. Select a cell and enter "123", etc
  3. Stop recording

Then you will get the following code
184267-img-20220317-083403.jpg

One more question
When the parameter of a user-defined function is a reference cell, the value of the parameter is incorrect, as shown below

184528-img-20220318-223529.jpg

184325-img-20220317-083442.jpg

{count} votes

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.