I have a list of cities w/ latitude and longitude that I have to find the
distance between any two of the cities. The formula I was given is this.....
69*(difference in latitudes)2 + (difference in longitudes)2
VLOOKUP is used for the differences and needs True or False.

I am in the process of learning how to apply what I know about Visual Basic to
VBA in Excel.  When I attempt to open a particular Workbook I get an error
message that says Excel "..has performed an illegal operation and will be shut
down."

In my job, we have large workbooks containing many tabs and many
formulas.  We are having a problem with these large workbooks and we
get an error message of "NOT ENOUGH MEMORY" when we try to open and/or
save these large workbooks.  Is here an easy fix to this problam?

When I post code from a module into a Word document, the pasted text is all
black even though the comments in the code module are green.
I used to be able to paste the code, green comment text and all, in the past
and I have NO IDEA what has changed with my system (besides ...

I am using Office XP on win2000 prof. When i open an excel work book, it
prompts "Not enough system resources to display completely".
My system has 1GB ram and 2000MB virtual memory.
My work book has some calculations & cell references from other workbooks

Does anyone know if there is a way to trap an event that is fired when
an embedded chart is deleted from a sheet?
Roy

I pull in sales data sometimes and it's much larger than a standard Excel
work sheet of 65,536 lines.  I'm using Excel 2003 and was wondering if I
could somehow import my data and when it gets to the end of a work sheet
that it would start importing into another work sheet.  Is this ...

Help (again :)) please:
My original posting concerned splitting a date/time into 2 fields where
my issue was with the text to column wizard. The solution a user posted
worked- I copied the orig col into a new one and formatted the 1st as a

how do i transfer data from excel to my maximer

When typing in the formula bar in Excel - I want to be able to advance to the
next line (just as you would in Word).  How do I do that?  Pressng enter just
takes me to the next cell....

How can I map my templates in Excel (using 97 version).
I can do this in Word under Tools and Options, but I can't find this same
function in Excel.
Thank you.

The heading expresses our distress at a loss to the community of
Excel.
It is with the greatest of sadness that I must report the news that
Frank Kabel has died in a tragic accident whilst on holiday in his

Is it possible to pass in a variable to Excel when you open a specific Excel
document?  If yes, would this work if the document was opened via a
hyperlink?

Pls advise how to use excel to input data into dbf

I have Firefox set up as my default browser, which is the way I want
it.  Unfortunately, some Microsoft-subservient outfits design their
websites so that they only work with IExplorer.
Is there a way to force a hyperlink to use a specific browser?