| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using &Chr$(39)& as substitute for ' in VBA
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nesting the SUBSTITUTE formula | Excel Worksheet Functions | |||
| Substitute Formula | Excel Worksheet Functions | |||
| Substitute ,replace and delete in a cell. | Excel Worksheet Functions | |||
| SUBSTITUTE (more than one in Excel ?) | New Users to Excel | |||
| substitute | Excel Worksheet Functions | |||
Threaded Mode
