I don’t know if the code highlighting works with indented code blocks. You may need to use three backticks eg. ```vb
Sub test()
Dim x As Long
With ActiveCell
For i = 1 To 1000
x = 91 * i
If Right(x, 2) = "22" Then
ActiveCell.Offset(m).Value = i
m = m + 1
End If
Next i
End With
End Sub
All </> does is indent whatever is selected four spaces.
If what is pasted in has lines that are indented four spaces they will be seen the same as if they had been selected and then indented. A common gotcha is pasted in code with # comments and underscores that get seen as intentional Markdown syntax when they are not.
I don’t know what the “generic” highlighter highlights other than Strings, Ints, and certain words common to various languages.
IIRC, that setting is there so it will apply code formatting/highlighting to space indented code and fenced code blocks. On Meta, that setting is not enabled.