View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Paul987[_16_] Paul987[_16_] is offline
external usenet poster
 
Posts: 1
Default 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