VBA to input ="=" into a cell?

[RockandGrohl]

The inclusion of multiple equals and quote marks is breaking VBA's little brain - and mine!

Have tried this:

Range(Cells(2, "Q"), Cells(x, "Q")).Value = "=" & """ & " = " & """

To no luck, it just displays false.

I want the end result in the cell to be exactly:

="="

Which would then be displayed as "="

Thanks!

 

[Fluff]

As this is now a totally different question, it needs a new thread. Thanks