The single quote is O.K. inside a string:

Sub Macro1()
Dim s As String
s = " ' "
Cells(1, 1).Value = s
End Sub


Make your equation as a string variable and then deposit it in a cell
--
Gary''s Student


"Paul987" wrote:

>
> I'm trying to set the value of cells to exactly the following:
>
> ='120!TA_;|={''Sheets(3).Cells(a, 1''}'}
>
> I seem to be having a far more difficult time with the line than I
> should be.
> The ' comments everything behind it out.
>
> Sheets(3).Cells(a, 33) = ????
> If someone could throw me a bone here, I'd appreciate it. TIA
>
>
> --
> Paul987
> ------------------------------------------------------------------------
> Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
> View this thread: http://www.excelforum.com/showthread...hreadid=522246
>
>