> CodeInspector is proposing replacement of Right$ function by a String Function
`Option Explicit
Sub Test_UseOfVariantReturningStringFunction()
Dim TestVar As String
Dim lary_Temp() As String
'correct - both Right and Trim are marked
TestVar = Right(Trim(Replace(lary_Temp(UBound(lary_Temp)), """", " ", , , vbTextCompare)), 1)
'correct - only Right is marked
TestVar = Right(Trim$(Replace(lary_Temp(UBound(lary_Temp)), """", " ", , , vbTextCompare)), 1)
'wrong - Right$ is also m