Re: Writing VBA Script
- From: "Bob Barrows [MVP]" <reb01501@xxxxxxxxxxxxxxx>
- Date: Tue, 20 May 2008 10:01:53 -0400
subvanpatent wrote:
I am trying to write a script to help me determine the Mean Time
Between Repair for equipment. I played with it all day yesterday but
was not able to figure it out. Right now I have to enter the string
manually. The formula I am using is
"=AVERAGE(C7-C6,C6-C5,C5-C4,C4-C3,C3-C2)" where C7 would be the
latest date to C2 the earliest date. As you can see this would
become cumbersome with numerous dates. --
Jim
Boy, are you in the wrong place!! :-)
1. VBA is not vbscript.
2. inetsdk refers to programming internet applications, not Office
It looks like you are using Excel, so you need to go into the Office
Solutions node over there in the table of contents and navigate to the
Excel VBA group(s).
There is also a much-used forum for Excel users at
http://www.mrexcel.com/forum/index.php?s=842adad78fef7834e54f98f657ea4d0c
if you prefer that route
--
Microsoft MVP -- ASP/ASP.NET
Please reply to the newsgroup. The email account listed in my From
header is my spam trap, so I don't check it very often. You will get a
quicker response by posting to the newsgroup.
.
- References:
- Writing VBA Script
- From: subvanpatent
- Writing VBA Script
- Prev by Date: Writing VBA Script
- Previous by thread: Writing VBA Script
- Index(es):
Relevant Pages
|
|
