Hi there, and welcome to the board!
First of all, you don't need to select a cell to do something with it. That is one of the first things you need to learn. This is done by almost every single beginner I've ever seen - including myself! You can shorten them to...
Cells(2, 2).Value = "not inkara"
A couple things to note.
1) I used
Value instead of
Formula or
FormulaR1C1. If you're just putting a value into a cell(s), then that is all you need. If you're putting in a formula, then use the
Formula property. There is also a
FormulaLocal and
FormulaR1C1Local. The best thing I can tell you is to look it up in the Help files, which are invaluable to a coder.
2) The basic differences between
Formula and
FormulaR1C1Local is the latter uses R1C1 style. If you look in the help files it should give an example of how they use it. You can use R1C1 reference style in a few different ways, both in a spreadsheet and in VBA. Basically it's a relative range which is based on the
Row and
Column.
3) No need to Activate anything. Activating a range is like when you select a range, then act on that range. The acting on the range is the activation, i.e. entering a value/formula, or right clicking it. In code you can just cut to the chase and enter the Value/Formula.
HTH