- Search ExcelTip.com
directly from Excel
- Get immediate access to the
"Tip of the Hour"
- View hundreds of Microsoft
Excel tips with a click of a button
- Absolutely
Free - Click
here to download
Make your Amazon.com purchases by clicking the graphic below
|
Excel Tip .com - Mailing List Thread Index
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Output of your job "list"
- To: Firstname Lastname <list@EXCELTIP.COM>
- Subject: Output of your job "list"
- From: "L-Soft list server at PEACH.EASE.LSOFT.COM (1.8e)" <LISTSERV@PEACH.EASE.LSOFT.COM>
- Date: Sun, 27 Jul 2003 12:11:41 -0400
- Delivered-to: speakerb-exceltip:com-list@EXCELTIP.COM
> search excel in excel-g
-> 100 matches (more available).
Item # Date Time Recs Subject
------ ---- ---- ---- -------
000001 95/04/27 04:19 26 Ohter MS lists
000002 95/04/27 08:27 13 OFF SUB :)
000003 95/04/27 09:38 17 Other MS lists
000004 95/04/27 09:41 15 Re: OFF SUB :)
000005 95/04/27 08:58 37 Re: Ohter MS lists
000006 95/04/27 12:19 24 Introduction and ques on page break
000007 95/04/27 12:43 33 Introduction and ques on page break -Reply
000008 95/04/27 12:47 13 Changing text to values.
000009 95/04/27 10:27 32 Re: Changing text to values.
000010 95/04/27 19:35 9 is there ftp sit for excel v. 5.0
000011 95/04/27 13:39 20 Re: Changing text to values.
000012 95/04/27 10:48 16 An Unsolved Mystery
000013 95/04/27 15:11 52 Re: An Unsolved Mystery
000014 95/04/27 13:39 15 Re: is there ftp sit for excel v. 5.0
000015 95/04/27 13:47 21 Re: Changing text to values.
000016 95/04/27 17:00 32 Re: Changing text to values. -Reply
000017 95/04/27 16:46 54 Initial appeal for help
000018 95/04/27 17:16 76
000019 95/04/27 15:12 36 Excel-G Posting
000020 95/04/27 17:23 27 Re: Initial appeal for help
000021 95/04/27 15:32 15 Re: An Unsolved Mystery
000022 95/04/27 18:29 42 Re: EXCEL-G POSTING
000023 95/04/27 17:49 40 Re: Changing text to values. -Reply
000024 95/04/28 09:24 34 Re: Changing text to values.
000025 95/04/28 08:31 15 Re: An Unsolved Mystery
000026 95/04/28 09:50 21 Re: An Unsolved Mystery
000027 95/04/28 06:51 30 Re: First post ever
000028 95/04/28 12:54 49 Problem with Excel (Macintosh) - Program dies with Type 1 error
000029 95/04/28 13:53 38 Automating data entry
000030 95/04/28 16:25 10 Re: Automating data entry
000031 95/04/28 14:07 52 Re: Automating data entry
000032 95/04/29 16:14 8 thanks for all
000033 95/04/29 10:25 11 WORD List Address
000034 95/05/01 11:33 20 Re: WORD List Address
000035 95/05/01 17:54 26 Making Short-cut Keys
000036 95/05/01 12:32 75 Re: Automating data entry
000037 95/05/01 14:44 59 Re: Knowledge Base Files
000038 95/05/02 09:32 22 Re: Making Short-cut Keys
000039 95/05/02 10:10 50 Macro Speed
000040 95/05/02 03:13 16 Quicker Way to Make Pages?
000041 95/05/02 00:57 32 Re: Quicker Way to Make Pages?
000042 95/05/02 10:01 19 Re: Quicker Way to Make Pages?
000043 95/05/02 08:13 50 Macro Speed
000044 95/05/02 10:53 35 Re: Quicker Way to Make Pages?
000045 95/05/02 11:14 20 Conversion of Symphony File
000046 95/05/02 14:07 14 Re: Macro Speed
000047 95/05/02 18:19 19 Re: Conversion of Symphony File
000048 95/05/02 10:58 26 Re[2]: Conversion of Symphony File
000049 95/05/02 14:01 29 Re: Macro Speed
000050 95/05/02 20:15 78 Re: Macro Speed
000051 95/05/02 15:20 24 header and footer
000052 95/05/02 15:46 21 sum Problem
000053 95/05/02 23:02 42 RE. Shortcut key
000054 95/05/02 15:09 25 Re: sum Problem
000055 95/05/02 15:21 29 Re: sum Problem
000056 95/05/02 15:24 26 Re: sum Problem
000057 95/05/02 13:35 36 Re: Quicker Way to Make Pages?
000058 95/05/02 13:55 73 Re: Macro Speed
000059 95/05/02 17:37 40 Re: header and footer
000060 95/05/03 10:09 19 Re: Header and footer
000061 95/05/03 11:48 37 Re: Shortcut Key
000062 95/05/03 08:37 35 Re: sum Problem
000063 95/05/03 08:53 22 Pulling in copied cell
000064 95/05/03 13:44 48 Re: sum Problem
000065 95/05/03 12:50 59 Re: sum Problem
000066 95/05/03 14:45 15 Need method for automatic graph updating
000067 95/05/04 11:13 39 Macro Speed
000068 95/05/04 11:55 33 sum Problem
000069 95/05/04 09:37 24 charting unknown labels
000070 95/05/04 07:59 24 Changing Tooltip desc on custom button
000071 95/05/04 17:15 35 Re: Changing Tooltip desc on cu
000072 95/05/04 11:19 20 Re: Changing Tooltip desc on custom button
000073 95/05/04 09:55 35 Re: charting unknown labels
000074 95/05/04 12:46 15 Defaults
000075 95/05/04 12:32 17 Re: Defaults
000076 95/05/04 20:43 8
000077 95/05/04 12:49 50 Re: charting unknown labels
000078 95/05/04 13:19 42 Re: Defaults
000079 95/05/04 11:28 35 Re: charting unknown labels
000080 95/05/04 18:33 25 Cell Fromats?
000081 95/05/04 14:07 6
000082 95/05/04 12:22 8 Re: - no subject (01HQ3PBW6YMA000QBY) -
000083 95/05/04 15:49 11
000084 95/05/04 13:58 14 Re: Defaults
000085 95/05/04 16:33 28 Creating "blank" data file
000086 95/05/04 15:32 14 Re: Cell Fromats?
000087 95/05/04 14:17 31 Re: Cell Fromats?
000088 95/05/04 17:26 25 sum problem & new question
000089 95/05/04 15:20 24 Re: Cell Fromats?
000090 95/05/04 17:40 33 Re: Cell Fromats?
000091 95/05/05 09:43 20 Re: sum problem & new question
000092 95/05/04 21:20 40 Re: Defaults
000093 95/05/05 12:13 34 Dialog Boxes
000094 95/05/04 23:12 16 Re: sum problem & new question
000095 95/05/05 12:21 31 Dialog Boxes II
000096 95/05/04 22:18 16 Winfax & Excel
000097 95/05/05 08:41 35 Re: Cell Fromats?
000098 95/05/05 14:28 28 Re: Creating "blank" data file
000099 95/05/05 14:43 19 Re: sum problem & new question
000100 95/05/05 09:04 11
To order a copy of these postings, send the following command:
GETPOST EXCEL-G 1-100
>>> Item #1 (27 Apr 1995 04:19) - Ohter MS lists
Date: Thu, 27 Apr 1995 04:19:37 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "Marc Enschede, Decisco" <enschede@KNOWARE.NL>
>>> Item #2 (27 Apr 1995 08:27) - OFF SUB :)
Date: Thu, 27 Apr 1995 08:27:46 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Shawn Schiebrel <sschiebrel@OHSGH.ANG.AF.MIL>
>>> Item #3 (27 Apr 1995 09:38) - Other MS lists
Date: Thu, 27 Apr 1995 09:38:00 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Nathan Brindle <NATHAN@LSOFT.COM>
***************
and of course
EXCEL-L@PEACH.EASE.LSOFT.COM for Microsoft Excel Developers
^^^^^
>>> Item #4 (27 Apr 1995 09:41) - Re: OFF SUB :)
Date: Thu, 27 Apr 1995 09:41:02 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Nathan Brindle <NATHAN@LSOFT.COM>
>>> Item #5 (27 Apr 1995 08:58) - Re: Ohter MS lists
Date: Thu, 27 Apr 1995 08:58:45 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Harrish Permanan <harrishp@QUEENS.LIB.NY.US>
>>> Item #6 (27 Apr 1995 12:19) - Introduction and ques on page break
Date: Thu, 27 Apr 1995 12:19:22 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Comments: Converted from PROFS to RFC822 format by PUMP V2.2X
***************
for reporting on our bureau's 800 phone line, which i do by using
Excel 5.0. I have used excel for appx. two years starting with 4.0
^^^^^
and have done a lot with it. All except VB development. Thats why
>>> Item #7 (27 Apr 1995 12:43) - Introduction and ques on page break -Reply
Date: Thu, 27 Apr 1995 12:43:06 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ben Lowenthal <BLOWEN@WPGATE2.AB.UMD.EDU>
***************
Hi! I am Ben Lowenthal and have similar Excel background. I, too, am
^^^^^
grateful for this list. In order to get Page Breaks to show, use Tools,
***************
reporting on our bureau's 800 phone line, which i do by using
Excel 5.0. I have used excel for appx. two years starting with 4.0 and
^^^^^
have done a lot with it. All except VB development. Thats why i am glad
>>> Item #8 (27 Apr 1995 12:47) - Changing text to values.
Date: Thu, 27 Apr 1995 12:47:20 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ben Lowenthal <BLOWEN@WPGATE2.AB.UMD.EDU>
>>> Item #9 (27 Apr 1995 10:27) - Re: Changing text to values.
Date: Thu, 27 Apr 1995 10:27:19 PST
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: paul haggard <paul_haggard@STUDIO.DISNEY.COM>
>>> Item #10 (27 Apr 1995 19:35) - is there ftp sit for excel v. 5.0
Date: Thu, 27 Apr 1995 19:35:43 +0000
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "ASHRAF M. NAGEIB" <AMNAGEIB@FRCU.EUN.EG>
Subject: is there ftp sit for excel v. 5.0
^^^^^
***************
can anyone konw ftp site for excel v. 5.0..
^^^^^
>>> Item #11 (27 Apr 1995 13:39) - Re: Changing text to values.
Date: Thu, 27 Apr 1995 13:39:22 EST
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: John Stone <jstone@NSF.GOV>
>>> Item #12 (27 Apr 1995 10:48) - An Unsolved Mystery
Date: Thu, 27 Apr 1995 10:48:24 -0700
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "Mark James (415) 723-3167" <JAMES_M@HOSP.STANFORD.EDU>
>>> Item #13 (27 Apr 1995 15:11) - Re: An Unsolved Mystery
Date: Thu, 27 Apr 1995 15:11:13 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Bill Higgins-- Beam Jockey <HIGGINS@DAFFY.FNAL.GOV>
***************
I don't know why this happens. (In the future, it might be wise to
mention what kind of machine, operating system, and version of Excel
^^^^^
you're using. I'm a Mac guy running Excel 4.0 on a Mac IIvx. If you
^^^^^
*really* want somebody to troubleshoot interactions between your
***************
Also, I'll bet this advice is good even if you are running Excel on a
^^^^^
PC.
>>> Item #14 (27 Apr 1995 13:39) - Re: is there ftp sit for excel v. 5.0
Date: Thu, 27 Apr 1995 13:39:26 -0700
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Dennis Clouse <Dennis.Clouse@UCOP.EDU>
Subject: Re: is there ftp sit for excel v. 5.0
^^^^^
> can anyone konw ftp site for excel v. 5.0..
^^^^^
try ftp.cica.indiana.com/pub/pc/win3/excel or the mirror on ftp.cdrom.com
^^^^^
(BTW these are probably the two busiest FTP sites in the worls).
>>> Item #15 (27 Apr 1995 13:47) - Re: Changing text to values.
Date: Thu, 27 Apr 1995 13:47:25 -0700
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Dennis Clouse <Dennis.Clouse@UCOP.EDU>
>>> Item #16 (27 Apr 1995 17:00) - Re: Changing text to values. -Reply
Date: Thu, 27 Apr 1995 17:00:00 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ben Lowenthal <BLOWEN@WPGATE2.AB.UMD.EDU>
>>> Item #17 (27 Apr 1995 16:46) - Initial appeal for help
Date: Thu, 27 Apr 1995 16:46:00 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "ROSSI.CARLA" <CKR1@OAS.PSU.EDU>
***************
Thanks so much for creating this list for general EXCEL questions. I have
^^^^^
been monitoring the EXCEL-L list for a couple of months now through an
^^^^^
internal bulletin board at our school, but have never actually subscribed or
***************
I have recently converted a file that was orginally written in SYMPHONY to an
EXCEL 5.0 workbook file. The SYMPH file was about 1 meg in size. It is used
^^^^^
to do all of the necessary adjustments from our general ledger detail to
***************
on a 486, 66Mhz with 16 meg RAM machine. I have since split my original file
into two (each about 500K in size). If I had built in EXCEL to begin with, I
^^^^^
would have probably put into more subparts and linked together, but with the
***************
file to begin my year end process all over again. From what I have read in
the EXCEL manual it seems as though my links should be maintained as long as I
^^^^^
have both files open when I save as new name. Does it matter if I start with
***************
convert beginning balances to values and then do a File Combine Subtract
command to zero out all my values. Is there something similar in EXCEL?
^^^^^
***************
that print out as separate workpapers. I haven't been able to accomplish this
in EXCEL, since I can't save settings for something less than a Sheet (and I
^^^^^
didn't want to put all my various workpapers in separate sheets b/c of the
>>> Item #18 (27 Apr 1995 17:16)
Date: Thu, 27 Apr 1995 17:16:35 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Adam Cooper <turambar@GLUE.UMD.EDU>
To: excel-g@peach.ease.lsoft.com
^^^^^
Subject: Excel 4.0 Macros in version 5.0
^^^^^
Newsgroups: comp.apps.spreadsheets
***************
I recently upgraded to Excel 5.0, but have not yet experimented much with
^^^^^
its Visual Basic capabilities, as the upgrade came whilst I was in the
middle of a project I had been writing in Excel 4.0's macro language. My
^^^^^
question is this: has anyone noticed any problems using the older macro
>>> Item #19 (27 Apr 1995 15:12) - Excel-G Posting
Date: Thu, 27 Apr 1995 15:12:38 PST
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "LARRY P. SHREVE" <LARRY_P._SHREVE@CCMAIL.ANATCP.ROCKWELL.COM>
Subject: Excel-G Posting
^^^^^
***************
How did you do this? I'd be interested in details - I can't
duplicate it in my Excel (5.0c for Windows).
^^^^^
>>> Item #20 (27 Apr 1995 17:23) - Re: Initial appeal for help
Date: Thu, 27 Apr 1995 17:23:17 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "K. Kelly Close" <KKC@HYDROSPHERE.COM>
***************
> file to begin my year end process all over again. From what I have read in
> the EXCEL manual it seems as though my links should be maintained as long as I
^^^^^
> have both files open when I save as new name. Does it matter if I start with
>>> Item #21 (27 Apr 1995 15:32) - Re: An Unsolved Mystery
Date: Thu, 27 Apr 1995 15:32:58 -0700
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "Mark James (415) 723-3167" <JAMES_M@HOSP.STANFORD.EDU>
***************
Thanks for the advice. I negelected to give you the info that I have
Excel 5.0 version, through Windows 6.22, but from a network, not locally on my
^^^^^
486 IBM and with a HP Laserjet 4Si. I am a novice, not only with Excel, but in
^^^^^
protocol!
>>> Item #22 (27 Apr 1995 18:29) - Re: EXCEL-G POSTING
Date: Thu, 27 Apr 1995 18:29:18 GMT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Comments: MEMO 04/27/95 17:26:00
From: JOE MEYER <JMEYER@EMAIL.USPS.GOV>
Subject: Re: EXCEL-G POSTING
^^^^^
>>> Item #23 (27 Apr 1995 17:49) - Re: Changing text to values. -Reply
Date: Thu, 27 Apr 1995 17:49:02 PST
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "LARRY P. SHREVE" <LARRY_P._SHREVE@CCMAIL.ANATCP.ROCKWELL.COM>
>>> Item #24 (28 Apr 1995 09:24) - Re: Changing text to values.
Date: Fri, 28 Apr 1995 09:24:35 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "Sverre.Steen" <steen@VLAB.MARINTEK.SINTEF.NO>
>>> Item #25 (28 Apr 1995 08:31) - Re: An Unsolved Mystery
Date: Fri, 28 Apr 1995 08:31:26 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Christopher Morse <CTMorse@AOL.COM>
>>> Item #26 (28 Apr 1995 09:50) - Re: An Unsolved Mystery
Date: Fri, 28 Apr 1995 09:50:02 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Comments: Converted from PROFS to RFC822 format by PUMP V2.2X
>>> Item #27 (28 Apr 1995 06:51) - Re: First post ever
Date: Fri, 28 Apr 1995 06:51:19 -0700
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Sarah H Gates <gatessh@IMD1.CBS.STATE.OR.US>
>>> Item #28 (28 Apr 1995 12:54) - Problem with Excel (Macintosh) - Program dies with Type 1 error
Date: Fri, 28 Apr 1995 12:54:02 -0600
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Comments: RFC822 error: <W> Incorrect or incomplete address field found and
***************
From: Phillip Hicks <phicks@AOC.NRAO.EDU>
Subject: Problem with Excel (Macintosh) - Program dies with Type 1 error
^^^^^
X-To: EXCEL-L@PEACH.EASE.LSOFT.COM
^^^^^
Excel'ers,
^^^^^
We are having a problem with Excel 5.0 running on a Quadra 700 (7.0.1,
^^^^^
tuned). By using the Excel macro language, I have designed a log keeping
^^^^^
program for our observatory. The application dies with a "Type 1" (bus
***************
named like dmf..... , some 20 characters long. All of them are typed as
Excel documents.
^^^^^
Once I get the program going again, I unhide my macro file and found that
by merely scrolling down to a particular cell ($A$640), Excel would die
^^^^^
with the Type 1 error. I could view cell $A$639 and cell $B$640 with no
>>> Item #29 (28 Apr 1995 13:53) - Automating data entry
Date: Fri, 28 Apr 1995 13:53:24 -0600
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Rick Linsk/Asbury Park Press <linsk@EARTH.USA.NET>
***************
I have a computer printout that I'm typing into Excel for eventual
^^^^^
database analysis.
>>> Item #30 (28 Apr 1995 16:25) - Re: Automating data entry
Date: Fri, 28 Apr 1995 16:25:49 EST
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "Ken Nellis, Telenetics" <"fuzzy::nellis"@NRLVAX.NRL.NAVY.MIL>
>>> Item #31 (28 Apr 1995 14:07) - Re: Automating data entry
Date: Fri, 28 Apr 1995 14:07:56 -0700
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Cynthia S Quarterman <quartecs@IMD1.CBS.STATE.OR.US>
***************
>
> I have a computer printout that I'm typing into Excel for eventual
^^^^^
> database analysis.
>>> Item #32 (29 Apr 1995 16:14) - thanks for all
Date: Sat, 29 Apr 1995 16:14:00 +0000
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "ASHRAF M. NAGEIB" <AMNAGEIB@FRCU.EUN.EG>
>>> Item #33 (29 Apr 1995 10:25) - WORD List Address
Date: Sat, 29 Apr 1995 10:25:53 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ron Krug <takenote@FREENET.MB.CA>
>>> Item #34 (1 May 1995 11:33) - Re: WORD List Address
Date: Mon, 1 May 1995 11:33:16 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "Dowling, Nick" <dow1com@BU.BBC.CO.UK>
>>> Item #35 (1 May 1995 17:54) - Making Short-cut Keys
Date: Mon, 1 May 1995 17:54:27 G+3
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Mansour Al-Mazroui <MEF3014@SAKAAU03.BITNET>
***************
Can someone tell me the way to make short-cut keys for some commands
that are frequently used in MS EXCEL ver. 5.0. For example if i want to
^^^^^
inserting a column just make short-cut key let us say CTRL+F1 or for deleting
>>> Item #36 (1 May 1995 12:32) - Re: Automating data entry
Date: Mon, 1 May 1995 12:32:18 PST
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "LARRY P. SHREVE" <LARRY_P._SHREVE@CCMAIL.ANATCP.ROCKWELL.COM>
***************
It appears from your comments that you are probably using Excel
^^^^^
5.0. Based on that assumption, I have several questions/comments.
***************
not using macros _unless_ they truly save time and effort.
Especially since Excel offers so many built-in tools.
^^^^^
<Rick Linsk/Asbury Park Press wrote:
<I have a computer printout that I'm typing into Excel for
^^^^^
<eventual database analysis.
***************
Wizard come up when you use menu item File/Open and choose text files.
Much, much, much, much better than Excel 4.0's Data/Parse.
^^^^^
>>> Item #37 (1 May 1995 14:44) - Re: Knowledge Base Files
Date: Mon, 1 May 1995 14:44:25 PST
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "LARRY P. SHREVE" <LARRY_P._SHREVE@CCMAIL.ANATCP.ROCKWELL.COM>
***************
X-To: WORLD.WCARPEN1_at_SOFTSWITCH@ccmail.anatcp.rockwell.com,
Excel-l@peach.ease.lsoft.com
^^^^^
***************
same file with full-text search built in). Also helpful for the
Excel developer (or hacker) is WE0993.EXE (Thats: 'W' 'E' 'zero'):
^^^^^
a very complete list of xlConstants; it gives all the objects that
>>> Item #38 (2 May 1995 09:32) - Re: Making Short-cut Keys
Date: Tue, 2 May 1995 09:32:00 PDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ferrero Ed E <ferreroe@MSMAILNT.BHPESE.OZ.AU>
***************
Most menu commands in Excel 5.0 have shortcut keys.
^^^^^
To find the shortcut keys in Excel;
^^^^^
>>> Item #39 (2 May 1995 10:10) - Macro Speed
Date: Tue, 2 May 1995 10:10:17 +0800
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ray Smith <ismithr@INFO.CURTIN.EDU.AU>
***************
move one cell at a time to calculate the "mean sqaure" part of the process,
which slows the macro down quite considerably. I am using excel 4.0 on a
^^^^^
6100/66 power mac.
>>> Item #40 (2 May 1995 03:13) - Quicker Way to Make Pages?
Date: Tue, 2 May 1995 03:13:16 -1000
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ken Wells <v73c@ALOHA.NET>
***************
I am a new Excel 5 user. I have a requirement to make about 100 "pages"
^^^^^
(books) within a single spreadsheet file. I am trying to find a quick(er)
>>> Item #41 (2 May 1995 00:57) - Re: Quicker Way to Make Pages?
Date: Tue, 2 May 1995 00:57:46 -0600
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Vance Wilber <wilbe007@GOLD.TC.UMN.EDU>
***************
At 7:13 AM 5/2/95, Ken Wells wrote:
>I am a new Excel 5 user. I have a requirement to make about 100 "pages"
^^^^^
>(books) within a single spreadsheet file. I am trying to find a quick(er)
>>> Item #42 (2 May 1995 10:01) - Re: Quicker Way to Make Pages?
Date: Tue, 2 May 1995 10:01:32 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "Dowling, Nick" <dow1com@BU.BBC.CO.UK>
***************
>I am a new Excel 5 user. I have a requirement to make about 100 "pages"
^^^^^
>(books) within a single spreadsheet file. I am trying to find a
>>> Item #43 (2 May 1995 08:13) - Macro Speed
Date: Tue, 2 May 1995 08:13:29 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Rick Brenner x1818 <rlb1818@MOON.DRAPER.COM>
***************
move one cell at a time to calculate the "mean sqaure" part of the process,
which slows the macro down quite considerably. I am using excel 4.0 on a
^^^^^
6100/66 power mac.
>>> Item #44 (2 May 1995 10:53) - Re: Quicker Way to Make Pages?
Date: Tue, 2 May 1995 10:53:42 EST
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Dave Brown <brownd@VRINET.COM>
>>> Item #45 (2 May 1995 11:14) - Conversion of Symphony File
Date: Tue, 2 May 1995 11:14:00 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "ROSSI.CARLA" <CKR1@OAS.PSU.EDU>
***************
file and then executed a File Combine Subtract (same file) command to "zero"
out the cell contents. Is there a similar operation that works in Excel?
^^^^^
Thanks for any ideas.
>>> Item #46 (2 May 1995 14:07) - Re: Macro Speed
Date: Tue, 2 May 1995 14:07:54 +0100
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: WANDERING_TECCHIE <C.M.BOYLAN@LIVERPOOL-JOHN-MOORES.AC.UK>
***************
they add up in 60's, ie 15 minutes + 55 minutes does not equal 70 minutes
but 1 hour 10 minutes in Excel 4.0
^^^^^
>>> Item #47 (2 May 1995 18:19) - Re: Conversion of Symphony File
Date: Tue, 2 May 1995 18:19:00 +0100
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "David LANDGREN, PUB/PROD" <David.LANDGREN@OECD.ORG>
***************
> ...
> Is there a similar operation that works in Excel?
^^^^^
>>> Item #48 (2 May 1995 10:58) - Re[2]: Conversion of Symphony File
Date: Tue, 2 May 1995 10:58:02 PST
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Jeanne Brown <Jeanne_Brown@SMTPGWY.CANDLE.COM>
***************
> ...
> Is there a similar operation that works in Excel?
^^^^^
>>> Item #49 (2 May 1995 14:01) - Re: Macro Speed
Date: Tue, 2 May 1995 14:01:10 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ginny Farmer <gsf1@CORNELL.EDU>
***************
>they add up in 60's, ie 15 minutes + 55 minutes does not equal 70 minutes
>but 1 hour 10 minutes in Excel 4.0
^^^^^
>
>>> Item #50 (2 May 1995 20:15) - Re: Macro Speed
Date: Tue, 2 May 1995 20:15:48 +0200
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Jan =?iso-8859-1?Q?Holmb=E4ck?= <jan.holmback@SUMIT.SE>
***************
> move one cell at a time to calculate the "mean sqaure" part of the process,
> which slows the macro down quite considerably. I am using excel 4.0 on a
^^^^^
> 6100/66 power mac.
***************
as a basis if you want to calculate more complex statistical variables that
are not supported by Excel.
^^^^^
***************
This is (again, if you've read my messages about matrix operations in
Excel-L) an example of problems that are more efficiently solved in XLM
^^^^^
than in VBA. In VBA you'd have to loop through the range to achieve the
>>> Item #51 (2 May 1995 15:20) - header and footer
Date: Tue, 2 May 1995 15:20:29 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Vijay Saluja <VSALUJA@LAKERS.LSSU.EDU>
***************
it to print page 1, chart1, sheet1. Everytime I print I have to go
change it under the headers'footer box. is there anyway to make excel
^^^^^
open a worksheet that everytime has no footer or header. It gets
>>> Item #52 (2 May 1995 15:46) - sum Problem
Date: Tue, 2 May 1995 15:46:08 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Benjamin Bokich <bokich@ANDREWS.EDU>
***************
all the numbers with a value greater than, say, 25. How do I go about
instructing Excel to only sum those numbers that meet a certain
^^^^^
criteria? I've tried fooling around with both the 'sum' and 'if'
>>> Item #53 (2 May 1995 23:02) - RE. Shortcut key
Date: Tue, 2 May 1995 23:02:25 G+3
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Mansour Al-Mazroui <MEF3014@SAKAAU03.BITNET>
***************
> Can someone tell me the way to make short-cut keys for some commands
>that are frequently used in MS EXCEL ver. 5.0. For example if i want to
^^^^^
>inserting a column just make short-cut key let us say CTRL+F1 or for
***************
Ed Frerrero wrote:
>Most menu commands in Excel 5.0 have shortcut keys.
^^^^^
>To find the shortcut keys in Excel;
^^^^^
>Open Help
***************
Is it possible in EXCEL 5.0 to assign new shortcut key or can I change
^^^^^
the deafult shortcut key.
>>> Item #54 (2 May 1995 15:09) - Re: sum Problem
Date: Tue, 2 May 1995 15:09:15 GMT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Comments: MEMO 05/02/95 14:09:00
***************
>sum all the numbers with a value greater than, say, 25. How do I go
>about instructing Excel to only sum those numbers that meet a certain
^^^^^
>criteria? I've tried fooling around with both the 'sum' and 'if'
>>> Item #55 (2 May 1995 15:21) - Re: sum Problem
Date: Tue, 2 May 1995 15:21:47 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Chris Mohr <chrism@MPLS.MORT.COM>
***************
all the numbers with a value greater than, say, 25. How do I go about
instructing Excel to only sum those numbers that meet a certain
^^^^^
criteria? I've tried fooling around with both the 'sum' and 'if'
>>> Item #56 (2 May 1995 15:24) - Re: sum Problem
Date: Tue, 2 May 1995 15:24:15 CDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Frank Hubeny <hubeny@SSAX.COM>
***************
> all the numbers with a value greater than, say, 25. How do I go about
> instructing Excel to only sum those numbers that meet a certain
^^^^^
> criteria? I've tried fooling around with both the 'sum' and 'if'
>>> Item #57 (2 May 1995 13:35) - Re: Quicker Way to Make Pages?
Date: Tue, 2 May 1995 13:35:04 PST
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "LARRY P. SHREVE" <LARRY_P._SHREVE@CCMAIL.ANATCP.ROCKWELL.COM>
***************
>>
>>I am a new Excel 5 user. I have a requirement to make
^^^^^
>>about 100 "pages" (books) within a single spreadsheet
>>> Item #58 (2 May 1995 13:55) - Re: Macro Speed
Date: Tue, 2 May 1995 13:55:52 PST
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "LARRY P. SHREVE" <LARRY_P._SHREVE@CCMAIL.ANATCP.ROCKWELL.COM>
***************
Unfortunately, I know VBA in Excel5 for Windows but I'm not
^^^^^
an Excel4 programmer, so I apologize for not being able to give
^^^^^
you a working example.
But, to illustrate in Excel 5.0c for Windows (should be the same
^^^^^
in Excel4), the single array formula
^^^^^
***************
I almost didn't post this note to Excel-G, as I dislike
^^^^^
broadcasting partial solutions, so I hope this points you
>>> Item #59 (2 May 1995 17:37) - Re: header and footer
Date: Tue, 2 May 1995 17:37:17 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Charles Forrest <libcgf@EMORY.EDU>
***************
all my spreadsheets with the filename/date/time in the lower right hand
corner, and would like it very much if Excel would do this automatically.
^^^^^
Any assistance is greatly appreciated.
***************
> it to print page 1, chart1, sheet1. Everytime I print I have to go
> change it under the headers'footer box. is there anyway to make excel
^^^^^
> open a worksheet that everytime has no footer or header. It gets
>>> Item #60 (3 May 1995 10:09) - Re: Header and footer
Date: Wed, 3 May 1995 10:09:00 PDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ferrero Ed E <ferreroe@MSMAILNT.BHPESE.OZ.AU>
***************
"Save the workbook as a template named BOOK.XLT in the XLSTART
directory in the directory where you installed Microsoft Excel"
^^^^^
>>> Item #61 (3 May 1995 11:48) - Re: Shortcut Key
Date: Wed, 3 May 1995 11:48:00 PDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ferrero Ed E <ferreroe@MSMAILNT.BHPESE.OZ.AU>
***************
> Is it possible in EXCEL 5.0 to assign new shortcut key or
^^^^^
>can I change the deafult shortcut key.
***************
which you may use. Whereas the already defined shortcut keys
in Excel, once you get used to them, are available on any machine
^^^^^
you might happen to use.
>>> Item #62 (3 May 1995 08:37) - Re: sum Problem
Date: Wed, 3 May 1995 08:37:11 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "Sverre.Steen" <steen@VLAB.MARINTEK.SINTEF.NO>
***************
> all the numbers with a value greater than, say, 25. How do I go about
> instructing Excel to only sum those numbers that meet a certain
^^^^^
> criteria?
>>> Item #63 (3 May 1995 08:53) - Pulling in copied cell
Reply-To: noeljohn@norse.luther.edu
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: John Noel <NOELJOHN@NORSE.LUTHER.EDU>
***************
copy command can be used to pull the contents of another
cell into the destination cell. In Excel it seems that I have to
^^^^^
leave the destination cell, go to the source cell and then
execute the copy command. Is there any way to replicate the
Lotus procedure in Excel?
^^^^^
>>> Item #64 (3 May 1995 13:44) - Re: sum Problem
Date: Wed, 3 May 1995 13:44:00 PDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: King Dean <dmking@SUNBURY01.DATASCI.CO.UK>
***************
You might like to read about Array Formulas and Array Constants in one of
the many books on Excel to understand what is happening here.
^^^^^
***************
----------
From: owner-excel-g
^^^^^
To: Multiple recipients of list EXCEL-G
^^^^^
Subject: Re: sum Problem
***************
all the numbers with a value greater than, say, 25. How do I go about
instructing Excel to only sum those numbers that meet a certain
^^^^^
criteria? I've tried fooling around with both the 'sum' and 'if'
>>> Item #65 (3 May 1995 12:50) - Re: sum Problem
Date: Wed, 3 May 1995 12:50:30 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Shide Zhang <szhang@BCM.TMC.EDU>
***************
} You might like to read about Array Formulas and Array Constants in one of
} the many books on Excel to understand what is happening here.
^^^^^
}
***************
} ----------
} From: owner-excel-g
^^^^^
} To: Multiple recipients of list EXCEL-G
^^^^^
} Subject: Re: sum Problem
***************
} all the numbers with a value greater than, say, 25. How do I go about
} instructing Excel to only sum those numbers that meet a certain
^^^^^
} criteria? I've tried fooling around with both the 'sum' and 'if'
>>> Item #66 (3 May 1995 14:45) - Need method for automatic graph updating
Date: Wed, 3 May 1995 14:45:46 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "Kevin Nishimuta (205)437-3211" <usmed7gz@IBMMAIL.COM>
***************
unsightly dead areas in those graphs where data has not yet been added.
Any ideas? I am using Excel 4.0, the spreadsheet is approximately
^^^^^
100 columns X 200 rows in size and growing daily.
>>> Item #67 (4 May 1995 11:13) - Macro Speed
Date: Thu, 4 May 1995 11:13:27 +0100
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Olav Mjelde <Omj@BBB.NO>
>>> Item #68 (4 May 1995 11:55) - sum Problem
Date: Thu, 4 May 1995 11:55:42 +0100
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Olav Mjelde <Omj@BBB.NO>
>>> Item #69 (4 May 1995 09:37) - charting unknown labels
Date: Thu, 4 May 1995 09:37:30 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Dale Sykora <DaleSyk@AOL.COM>
***************
I have a question concerning the creation of a chart in MS Excel ver 5.0 for
^^^^^
Win. I am trying to create a line chart with data and both X and Y axis
>>> Item #70 (4 May 1995 07:59) - Changing Tooltip desc on custom button
Date: Thu, 4 May 1995 07:59:01 PDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Julia Bradley <JBRADLEY@IBM.MTSAC.EDU>
***************
BTW, using Excel 5.0 on a PC.
^^^^^
>>> Item #71 (4 May 1995 17:15) - Re: Changing Tooltip desc on cu
Date: Thu, 4 May 1995 17:15:05 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "Dowling, Nick" <dow1com@BU.BBC.CO.UK>
>>> Item #72 (4 May 1995 11:19) - Re: Changing Tooltip desc on custom button
Date: Thu, 4 May 1995 11:19:22 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Paul McFedries <paulmcf@NOC.TOR.HOOKUP.NET>
***************
Paul McFedries (paulmcf@hookup.net)
Author of "Excel 5 SuperBook"
^^^^^
Sams Publishing, 201 West 103rd Street, Indianapolis, IN, USA 46290
>>> Item #73 (4 May 1995 09:55) - Re: charting unknown labels
Date: Thu, 4 May 1995 09:55:29 +0000
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "K. Kelly Close" <KKC@HYDROSPHERE.COM>
***************
> I have a question concerning the creation of a chart in MS Excel ver 5.0 for
^^^^^
> Win. I am trying to create a line chart with data and both X and Y axis
>>> Item #74 (4 May 1995 12:46) - Defaults
Date: Thu, 4 May 1995 12:46:12 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Cindy Ketcham <Cindy=Ketcham%Auxiliary%Starfleet@VINES.INDWES.EDU>
***************
defaults. My goals are as follows:
1. change the default save directory from the Excel system folder
^^^^^
to a document folder that I've created.
2. open a modified worksheet (changes in printer setup) upon Excel
^^^^^
startup.
>>> Item #75 (4 May 1995 12:32) - Re: Defaults
Date: Thu, 4 May 1995 12:32:31 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: mary <meadows@STOCK.COM>
***************
Is this what you mean. I could not find a way
to change the default save directory in Excel.
^^^^^
>>> Item #76 (4 May 1995 20:43)
Date: Thu, 4 May 1995 20:43:59 +0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Tolga Ulas <tulas@PROMETE.TETM.TUBITAK.GOV.TR>
>>> Item #77 (4 May 1995 12:49) - Re: charting unknown labels
Date: Thu, 4 May 1995 12:49:11 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Shide Zhang <szhang@BCM.TMC.EDU>
***************
You might need to tell Excel that first column is X axis label and first
^^^^^
row is name labels (legend text)
***************
}
} > I have a question concerning the creation of a chart in MS Excel ver 5.0 for
^^^^^
} > Win. I am trying to create a line chart with data and both X and Y axis
>>> Item #78 (4 May 1995 13:19) - Re: Defaults
Date: Thu, 4 May 1995 13:19:55 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Shide Zhang <szhang@BCM.TMC.EDU>
***************
} defaults. My goals are as follows:
} 1. change the default save directory from the Excel system folder
^^^^^
} to a document folder that I've created.
Under Windows Program maneger, select Excel icon, goto file/property and
^^^^^
set working dir to the folder you choose.
} 2. open a modified worksheet (changes in printer setup) upon Excel
^^^^^
} startup.
***************
grogram group in program maneger. You will have an icon labled *.XLT; Next
time when you double-click on the icon, program manager will load EXCEL,
^^^^^
if it has not been loaded, and open the template file. You can set up as
>>> Item #79 (4 May 1995 11:28) - Re: charting unknown labels
Date: Thu, 4 May 1995 11:28:47 PST
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Jeanne Brown <Jeanne_Brown@SMTPGWY.CANDLE.COM>
***************
> I have a question concerning the creation of a chart in MS Excel ver
^^^^^
5. 0 for
>>> Item #80 (4 May 1995 18:33) - Cell Fromats?
Date: Thu, 4 May 1995 18:33:30 -1000
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ken Wells <v73c@ALOHA.NET>
>>> Item #81 (4 May 1995 14:07)
Date: Thu, 4 May 1995 14:07:35 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: mary <meadows@STOCK.COM>
>>> Item #82 (4 May 1995 12:22) - Re: - no subject (01HQ3PBW6YMA000QBY) -
Date: Thu, 4 May 1995 12:22:50 -0700
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "Mark James (415) 723-3167" <JAMES_M@HOSP.STANFORD.EDU>
>>> Item #83 (4 May 1995 15:49)
Date: Thu, 4 May 1995 15:49:45 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Alan Seid <apstrl@WVNVAXA.WVNET.EDU>
>>> Item #84 (4 May 1995 13:58) - Re: Defaults
Date: Thu, 4 May 1995 13:58:57 +0000
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "K. Kelly Close" <KKC@HYDROSPHERE.COM>
***************
> 1. change the default save directory from the Excel system folder
^^^^^
> to a document folder that I've created.
***************
In Program Manager, change the working directory in the File
Properties for the Excel Icon.
^^^^^
>>> Item #85 (4 May 1995 16:33) - Creating "blank" data file
Date: Thu, 4 May 1995 16:33:00 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "ROSSI.CARLA" <CKR1@OAS.PSU.EDU>
***************
and said "same number - same number = zero, but left text, formulas, etc.
unchanged. There surely must be something similar available in Excel. I've
^^^^^
never written in VBA, maybe someone could help me with the code. Is there a
>>> Item #86 (4 May 1995 15:32) - Re: Cell Fromats?
Date: Thu, 4 May 1995 15:32:45 EDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: mary <meadows@STOCK.COM>
>>> Item #87 (4 May 1995 14:17) - Re: Cell Fromats?
Date: Thu, 4 May 1995 14:17:13 PST
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "LARRY P. SHREVE" <LARRY_P._SHREVE@CCMAIL.ANATCP.ROCKWELL.COM>
>>> Item #88 (4 May 1995 17:26) - sum problem & new question
Date: Thu, 4 May 1995 17:26:46 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Benjamin Bokich <bokich@ANDREWS.EDU>
***************
I suspect disk or computer problems, but if this strikes a cord out there
as an Excel problem, I'd be interested in hearing about it. TIA.
^^^^^
>>> Item #89 (4 May 1995 15:20) - Re: Cell Fromats?
Date: Thu, 4 May 1995 15:20:50 +0000
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "K. Kelly Close" <KKC@HYDROSPHERE.COM>
>>> Item #90 (4 May 1995 17:40) - Re: Cell Fromats?
Date: Thu, 4 May 1995 17:40:22 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Lou Weber <partner@CYBERNETICS.NET>
>>> Item #91 (5 May 1995 09:43) - Re: sum problem & new question
Date: Fri, 5 May 1995 09:43:00 PDT
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ferrero Ed E <ferreroe@MSMAILNT.BHPESE.OZ.AU>
>>> Item #92 (4 May 1995 21:20) - Re: Defaults
Date: Thu, 4 May 1995 21:20:36 -0400
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Rob Albertson <ALBERTSON@VAXA.CIS.SUNYCGCC.EDU>
***************
>defaults. My goals are as follows:
> 1. change the default save directory from the Excel system folder
^^^^^
> to a document folder that I've created.
> 2. open a modified worksheet (changes in printer setup) upon Excel
^^^^^
> startup.
***************
Cindy,
If you are using Excel 5.0, you can set the default save directory using
^^^^^
the Tools Menu, Options, and then the GENERAL Tab. From there, set the
***************
under the name book.xlt (as a template) and save it in the xlstart
subdirectory (located beneath the excel program directory). It is
^^^^^
explained in help under "Alternate startup directory" and then "Overview of
controlling what happens when you start Microsoft Excel"
^^^^^
>>> Item #93 (5 May 1995 12:13) - Dialog Boxes
Date: Fri, 5 May 1995 12:13:28 +0800
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ray Smith <ismithr@INFO.CURTIN.EDU.AU>
***************
certain step (hopefully shown by different pictures). I am currently using
the message command to do this, but this is quite dull. I am using excel
^^^^^
4.0 on the mac. Anyone have any suggestions?
>>> Item #94 (4 May 1995 23:12) - Re: sum problem & new question
Date: Thu, 4 May 1995 23:12:00 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Duncan Lyon <duncan_lyon@COLYBRAND.COM.AU>
>>> Item #95 (5 May 1995 12:21) - Dialog Boxes II
Date: Fri, 5 May 1995 12:21:19 +0800
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Ray Smith <ismithr@INFO.CURTIN.EDU.AU>
***************
much computer illiterate and would probably make some kind of mistake). Is
this possible? Using Excel 4.0 on the mac.
^^^^^
>>> Item #96 (4 May 1995 22:18) - Winfax & Excel
Date: Thu, 4 May 1995 22:18:38 -0700
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: Robert Grutko <romad@ESKIMO.COM>
Subject: Winfax & Excel
^^^^^
***************
I was hoping someone, somewhere would know the answer to my problem.
I use Excel 5, and recently loaded Delrina Winfax onto my system.
^^^^^
Now, whenever I try to exit Excel, It makes me save msexcel4.xls over and
^^^^^
over again. I tried to unhide, and close the file, but the next time I
>>> Item #97 (5 May 1995 08:41) - Re: Cell Fromats?
Date: Fri, 5 May 1995 08:41:58 -0500
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "Sverre.Steen" <steen@VLAB.MARINTEK.SINTEF.NO>
>>> Item #98 (5 May 1995 14:28) - Re: Creating "blank" data file
Date: Fri, 5 May 1995 14:28:00 +0100
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "David LANDGREN, PUB/PROD" <David.LANDGREN@OECD.ORG>
>>> Item #99 (5 May 1995 14:43) - Re: sum problem & new question
Date: Fri, 5 May 1995 14:43:00 +0100
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "David LANDGREN, PUB/PROD" <David.LANDGREN@OECD.ORG>
>>> Item #100 (5 May 1995 09:04)
Date: Fri, 5 May 1995 09:04:02 -5
Reply-To: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
Sender: MS Excel General Q & A List <EXCEL-G@PEACH.EASE.LSOFT.COM>
^^^^^
From: "Carla J. Weaver" <weave021@GOLD.TC.UMN.EDU>
> --------------------------------------------------------------------
> mail2web - Check your email from the web at
> http://mail2web.com/ .
|
And at your local bookseller
Excel Training Level I
Excel
Training Level II
Excel
Training Level III
Excel
VBA Training Level I
Excel
VBA Training Level II
View All Excel Training Programs
Formula Manager
Duplication
Manager
Text
Manager
Number
Manager
Add-ins
Collection
Spreadsheet
Assistant
Number
Manager
Add-ins
Collection
Spreadsheet
Assistant
View All Excel Add-Ins
|