Macro recording shows dot in the action

Santo Samuel Surja 1 Reputation point
2022-11-12T03:50:12.873+00:00

Hi I come across an issue that when I record a macro, it only gives a dot for the action.

This is a simple code, basicly what I am trying to do is fill a cell with the word "tes". Here is what I did

  1. I selected the cell A13
  2. Wrote "tes" in cell A13
  3. I pressed enter
  4. And so on until cell A17

Here is a screenshot of my macro code after I recorded it
259751-messageimage-1668224798934.jpg

Any help would be wonderful. Thanks in advance!

Developer technologies | Visual Basic for Applications
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Oskar Shon 866 Reputation points
    2022-11-12T07:20:29.577+00:00

    Something wrong with recorder.
    You should fix Office using control panel/programs/mod/fix on turning off all Office applications

    Anyway select and selection commend is not necessary commend and that lines you can tape in single line like

    range("A13:A17").value = "tes"  
    

    Regards

    0 comments No comments

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.