|
PureBytes Links
Trading Reference Links
|
<x-html><!DOCTYPE HTML PUBLIC "-//W3C//DTD W3 HTML//EN">
<HTML><HEAD>
<META content=text/html;charset=iso-8859-1 http-equiv=Content-Type>
<STYLE></STYLE>
<META content='"MSHTML 5.00.0910.1309"' name=GENERATOR></HEAD>
<BODY bgColor=#ffffff>This is a re-send of earlier send mail, and as it did not
arrive at the List-server,<BR>have had to split the mail in 2 seperate
mails(part 1 and part 2).<BR><BR>>One problem in Excel -- there is no place
to store "in cell" code bits and<BR>>pieces for future
reference.<BR>><BR>>Maybe someone can think of a simple library type
access system. I just store<BR>>them on emails that I send to myself. Pretty
primitive?<BR>---------------------------------------------------------------<BR><BR>You
can have in a cell:<BR> -the cell's formula itselve as printed
text<BR> or<BR>-the cell's formula outcomes as results<BR> <BR>both
are ASCI-text, but treated differently(eg one is invisable / hidden) and
choice<BR>is users. It requires for you to make the cell's formula to be the
cell's definite text.<BR>Tho you can Copy and Paste formulas to other programs,
a more natural way in Excel is<BR>to Copy and Paste the formulas over to another
Column, eg as virtual text.<BR><BR>Here are a few
ways:<BR><BR>
***Make a spare back-up copy of your WorkBook first***<BR><BR>In the Formula
Editor precede the " = " character (In the Cell Editor this is
the<BR>reference character for the Formula Mode) by the " ' "
character(In the Cell Editor<BR>this is a reference charcter for Display
Text).<BR>(The " ' " character will not be visable, only the formula
will be given, preceded<BR>by the " = " character).<BR><BR>A= the
Official MSExcel way<BR>B= the workaround <BR><BR>A. In the Excel program
Configuration:<BR> Choose
Tools|Options|Display|Window(options)|Formulas and on this
Display-TAB<BR> apply(=activate) the Formulas box in the
Window options section. Click OK.<BR> Back in your Sheet
copy all the formulas over to an empty remained
Column<BR> (eg Select the Column and in the WorkMenu
Click Edit|Copy and in the Sheet<BR> Click an empty
Columns Header(say M) and in the WorkMenu Click Insert|Copied
Cells<BR> and the column L (left of Column M) will be
inserted containing the formulas. <BR> Then preceed here
with B.1 for the perminent text-display (at point
B.1<BR> replace reading column A with the by you
applicable column).<BR> When you are finished with B.1
and the following B.#'s, then do not forget<BR> to
"undo" the above Excel program's configuration Option
again.<BR><BR>or<BR><BR>B. And this is asuming that you have all formulas in one
single column, and that you<BR> will also have to do
this for each column(that contain any formulas)
seperatly.<BR><BR> 1-Select Column A by Clicking the
column's spreadsheet Header(not your header),
here<BR> this is (capitol)
" A ". This will blacken the entire column
A.<BR> 2-On the WorkMenu Click
Edit|Replace<BR> 3-In the Dialog Window 1st field type
the " = " character (without quotation
marks)<BR> 4-In the Dialog Window 2nd field type the
" ` " and " = " characters (joined
and<BR> without the quotation
marks), eg it will look like
this:<BR>
`=<BR> 5-Click Replace All<BR>
6-Click Close<BR> 7-Back in the Sheet, Click the Column
A spreadsheet Header again to have the
entire<BR> column
selected(blackened)<BR> 8-On the WorkMenu click
Edit|Copy and in the Sheet click the Column M
spreadsheet<BR> Header(column M
is taken as an example).<BR> 9-On the WorkMenu Click
Insert|Copied Cells and the formulas from Column A will
be<BR> Copied over to Column
L<BR> 10-Return to Column A again by Clicking its spreadsheet
Header<BR> 11-On the WorkMenu Click Edit|Replace <BR>
12-In the Dialog Window 1st field type the " ` " and " = "
characters (joined and<BR>
without the quotation marks), eg it will look like
this:<BR> `=<BR>
13-In the Dialog Window 2nd field type the " = "
character<BR> 14-Click Replace All<BR> 15-Click
Close<BR><BR>This will have all the formulas being put back into their original
state again and<BR>the cells being put back to their normal display AND now you
have also created a<BR>seperate constant readable formula column. However, this
is not linked, so any changes<BR>made to the Column A formulas will not be
reflected in the Column L
copies. <BR><BR>Or see the
attached Microsoft Tips part-2 (toptips.html).<BR><BR>Regards,<BR>Ton Maas<BR><A
href="mailto:ms-irb@xxxxxx";>ms-irb@xxxxxx</A><BR><BR><BR><BR> <BR>-----
Original Message ----- <BR>From: Walter Lake <<A
href="mailto:wlake@xxxxxxxxx";>wlake@xxxxxxxxx</A>><BR>To: Metastock bulletin
board <<A
href="mailto:metastock@xxxxxxxxxxxxx";>metastock@xxxxxxxxxxxxx</A>><BR>Sent:
vrijdag 12 maart 1999 21:13<BR>Subject: Visual Basic code for a Stock
ticker<BR><BR>>snip----------------------------------------<BR></BODY></HTML>
</x-html>
Attachment Converted: "c:\eudora\attach\toptips.htm"
|