Having trouble Using Chr$(39) as substitute for '
 

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.

Sheets(3).Cells(a, 33) = ????
If someone could throw me a bone here, I'd appreciate it.


--
Paul987
------------------------------------------------------------------------
Paul987's Profile: http://www.excelforum.com/member.php...o&userid=24850
View this thread: http://www.excelforum.com/showthread...hreadid=521118