donpur
Last Activity: Nov 3 '09, 01:13 PM
Joined: Nov 2 '09
Location:
-
I believe the following web site will help you.http://library.thinkquest.org/26272/introto.htm -
Writing special character (eg. !) to excel
In Visual Basic I am attempting to write a formula that includes an explanation point out to an Excel cell. When I do, Excel puts extra single quotes into the formula. For example the following: ActiveCell.Form ulaR1C1 = "='Pricing - SIPs'!AE84+'Pri cing - Circuits'!AN83" writes the following into the cell: ='Pricing - SIPs'!'V84'+'Pr icing - Circuits'!'Y83'
An extra set of single quotes gets placed around the cell reference...
No activity results to display
Leave a comment: