Delta

I was reading about the delta function -- an engineering function available
from the analysis toolpak -- in a book and wanted to try it on a worksheet.
However, after typing =delta in a cell, I pressed ENTER by mistake without
entering the arguments. Surprising, the number -178323444 appeared in the
cell. Seems that delta = -178323444 is some kind of constant. Anyone knows
what it is exactly?

I am using Excel 2003.

Looks like it has to do with the internal workings of the Analysis Tookpak
VBA. Perhaps an offset into the DLL.

Run this code with a blank sheet active:

Sub ABBB()
Set nme = Workbooks("ATPVBAEN.XLA").Names
i = 2
Range("A1:B1").Value = Array("Name", "Refers To")
For Each nm In nme
Cells(i, 1) = nm.Name
Cells(i, 2) = "'" & nm.RefersTo
i = i + 1
Next
End Sub

--
Regards,
Tom Ogilvy

"Shatin" <[email protected]> wrote in message
news:[email protected]...
> I was reading about the delta function -- an engineering function
available
> from the analysis toolpak -- in a book and wanted to try it on a
worksheet.
> However, after typing =delta in a cell, I pressed ENTER by mistake without
> entering the arguments. Surprising, the number -178323444 appeared in the
> cell. Seems that delta = -178323444 is some kind of constant. Anyone knows
> what it is exactly?
>
> I am using Excel 2003.
>
>

And you can do this:

Sub AC()
Workbooks("ATPVBAEN.XLA").Sheets("REG").Copy After:= _
ActiveWorkbook.Sheets(Activeworkbook.sheets.count)
End Sub

Then you can look at the defined names that come with it.

--
Regards,
Tom Ogilvy


"Shatin" <[email protected]> wrote in message
news:[email protected]...
> I was reading about the delta function -- an engineering function
available
> from the analysis toolpak -- in a book and wanted to try it on a
worksheet.
> However, after typing =delta in a cell, I pressed ENTER by mistake without
> entering the arguments. Surprising, the number -178323444 appeared in the
> cell. Seems that delta = -178323444 is some kind of constant. Anyone knows
> what it is exactly?
>
> I am using Excel 2003.
>
>

Tom,

I can't run your code -- both Sub ABBB() and Sub AC():

Runtime error '9': Subscript out of range

"Tom Ogilvy" <[email protected]> wrote in message
news:%23Ho%[email protected]...
> Looks like it has to do with the internal workings of the Analysis Tookpak
> VBA. Perhaps an offset into the DLL.
>
> Run this code with a blank sheet active:
>
> Sub ABBB()
> Set nme = Workbooks("ATPVBAEN.XLA").Names
> i = 2
> Range("A1:B1").Value = Array("Name", "Refers To")
> For Each nm In nme
> Cells(i, 1) = nm.Name
> Cells(i, 2) = "'" & nm.RefersTo
> i = i + 1
> Next
> End Sub
>
> --
> Regards,
> Tom Ogilvy
>
> "Shatin" <[email protected]> wrote in message
> news:[email protected]...
> > I was reading about the delta function -- an engineering function
> available
> > from the analysis toolpak -- in a book and wanted to try it on a
> worksheet.
> > However, after typing =delta in a cell, I pressed ENTER by mistake
without
> > entering the arguments. Surprising, the number -178323444 appeared in
the
> > cell. Seems that delta = -178323444 is some kind of constant. Anyone
knows
> > what it is exactly?
> >
> > I am using Excel 2003.
> >
> >
>
>

Do you have an english version of the Analysis Toolpak VBA installed?

--
Regards,
Tom Ogilvy



"Shatin" <[email protected]> wrote in message
news:[email protected]...
> Tom,
>
> I can't run your code -- both Sub ABBB() and Sub AC():
>
> Runtime error '9': Subscript out of range
>
> "Tom Ogilvy" <[email protected]> wrote in message
> news:%23Ho%[email protected]...
> > Looks like it has to do with the internal workings of the Analysis
Tookpak
> > VBA. Perhaps an offset into the DLL.
> >
> > Run this code with a blank sheet active:
> >
> > Sub ABBB()
> > Set nme = Workbooks("ATPVBAEN.XLA").Names
> > i = 2
> > Range("A1:B1").Value = Array("Name", "Refers To")
> > For Each nm In nme
> > Cells(i, 1) = nm.Name
> > Cells(i, 2) = "'" & nm.RefersTo
> > i = i + 1
> > Next
> > End Sub
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> > "Shatin" <[email protected]> wrote in message
> > news:[email protected]...
> > > I was reading about the delta function -- an engineering function
> > available
> > > from the analysis toolpak -- in a book and wanted to try it on a
> > worksheet.
> > > However, after typing =delta in a cell, I pressed ENTER by mistake
> without
> > > entering the arguments. Surprising, the number -178323444 appeared in
> the
> > > cell. Seems that delta = -178323444 is some kind of constant. Anyone
> knows
> > > what it is exactly?
> > >
> > > I am using Excel 2003.
> > >
> > >
> >
> >
>
>

I've just installed it and can run your code now. Thanks!

"Tom Ogilvy" <[email protected]> wrote in message
news:[email protected]...
> Do you have an english version of the Analysis Toolpak VBA installed?
>
> --
> Regards,
> Tom Ogilvy
>
>
>
> "Shatin" <[email protected]> wrote in message
> news:[email protected]...
> > Tom,
> >
> > I can't run your code -- both Sub ABBB() and Sub AC():
> >
> > Runtime error '9': Subscript out of range
> >
> > "Tom Ogilvy" <[email protected]> wrote in message
> > news:%23Ho%[email protected]...
> > > Looks like it has to do with the internal workings of the Analysis
> Tookpak
> > > VBA. Perhaps an offset into the DLL.
> > >
> > > Run this code with a blank sheet active:
> > >
> > > Sub ABBB()
> > > Set nme = Workbooks("ATPVBAEN.XLA").Names
> > > i = 2
> > > Range("A1:B1").Value = Array("Name", "Refers To")
> > > For Each nm In nme
> > > Cells(i, 1) = nm.Name
> > > Cells(i, 2) = "'" & nm.RefersTo
> > > i = i + 1
> > > Next
> > > End Sub
> > >
> > > --
> > > Regards,
> > > Tom Ogilvy
> > >
> > > "Shatin" <[email protected]> wrote in message
> > > news:[email protected]...
> > > > I was reading about the delta function -- an engineering function
> > > available
> > > > from the analysis toolpak -- in a book and wanted to try it on a
> > > worksheet.
> > > > However, after typing =delta in a cell, I pressed ENTER by mistake
> > without
> > > > entering the arguments. Surprising, the number -178323444 appeared
in
> > the
> > > > cell. Seems that delta = -178323444 is some kind of constant. Anyone
> > knows
> > > > what it is exactly?
> > > >
> > > > I am using Excel 2003.
> > > >
> > > >
> > >
> > >
> >
> >
>
>

That would indicate the actual defined name DELTA is coming from the
Analysis Toolpak (funcreas.xla as I recall) itself, so you might try
something similar with that.

--
Regards,
Tom Ogilvy

"Shatin" <[email protected]> wrote in message
news:[email protected]...
> I've just installed it and can run your code now. Thanks!
>
> "Tom Ogilvy" <[email protected]> wrote in message
> news:[email protected]...
> > Do you have an english version of the Analysis Toolpak VBA installed?
> >
> > --
> > Regards,
> > Tom Ogilvy
> >
> >
> >
> > "Shatin" <[email protected]> wrote in message
> > news:[email protected]...
> > > Tom,
> > >
> > > I can't run your code -- both Sub ABBB() and Sub AC():
> > >
> > > Runtime error '9': Subscript out of range
> > >
> > > "Tom Ogilvy" <[email protected]> wrote in message
> > > news:%23Ho%[email protected]...
> > > > Looks like it has to do with the internal workings of the Analysis
> > Tookpak
> > > > VBA. Perhaps an offset into the DLL.
> > > >
> > > > Run this code with a blank sheet active:
> > > >
> > > > Sub ABBB()
> > > > Set nme = Workbooks("ATPVBAEN.XLA").Names
> > > > i = 2
> > > > Range("A1:B1").Value = Array("Name", "Refers To")
> > > > For Each nm In nme
> > > > Cells(i, 1) = nm.Name
> > > > Cells(i, 2) = "'" & nm.RefersTo
> > > > i = i + 1
> > > > Next
> > > > End Sub
> > > >
> > > > --
> > > > Regards,
> > > > Tom Ogilvy
> > > >
> > > > "Shatin" <[email protected]> wrote in message
> > > > news:[email protected]...
> > > > > I was reading about the delta function -- an engineering function
> > > > available
> > > > > from the analysis toolpak -- in a book and wanted to try it on a
> > > > worksheet.
> > > > > However, after typing =delta in a cell, I pressed ENTER by mistake
> > > without
> > > > > entering the arguments. Surprising, the number -178323444 appeared
> in
> > > the
> > > > > cell. Seems that delta = -178323444 is some kind of constant.
Anyone
> > > knows
> > > > > what it is exactly?
> > > > >
> > > > > I am using Excel 2003.
> > > > >
> > > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>