Microsoft KB Archive/38361: Difference between revisions
(importing KB archive) |
m (Text replacement - "&" to "&") |
||
Line 31: | Line 31: | ||
A3: =ATTACH.TEXT(1) | A3: =ATTACH.TEXT(1) | ||
A4: =SELECT("Title") | A4: =SELECT("Title") | ||
A5: =FORMULA("="& | A5: =FORMULA("="&""""&DEREF(A2)&"""") | ||
A6: =SELECT("") | A6: =SELECT("") | ||
A7: =RETURN() | A7: =RETURN() |
Latest revision as of 14:13, 21 July 2020
Entering a Chart Title from a Macro in Windows ExcelLast reviewed: November 4, 1994 |
2.x 3.00 4.00 4.00a 5.00 | 2.20 2.21 3.00 WINDOWS | OS/2 kbusage The information in this article applies to:
SUMMARYThe following is a macro that allows you to enter a title for a chart created by a macro or enter the title in an interactive manner: A1: =ACTIVATE("chart1") A2: =INPUT("Enter title of chart",2) A3: =ATTACH.TEXT(1) A4: =SELECT("Title") A5: =FORMULA("="&""""&DEREF(A2)&"""") A6: =SELECT("") A7: =RETURN() Note: there are four double quotation marks (") in each set before and after the DEREF(A2) statement. |
KBCategory: kbusage |
Last reviewed: November 4, 1994
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.