Mac Forum / Applications / Excel / January 2006

For Excel 2004, what is the syntax to obtain an entry from "get
international"?  The dictionary entry is a bit confusing and the
various permutations I've tried don't compile or fail at runtime.  E.g.
this fails at runtime:

Since I went from Mac OS 10.3 to 10.4, whenever I use the right-click
to access the contextual menus (say to align a cell) in Excel, I see an
extra set of options - ie Excel is duplicating all the menu options
each time I use it! I have to scroll down a long list and use the

How do I get more columns in a worksheet. It only goes up to column
"IV" now, and I want to add 200 more columns. (I have one column for
each day, going back over a year right now).

Hello, I am a teacher and I have to develop a course matrix. The course
has a duration of 2 months. I would like to come up with a formula that
allows me to write the first date in the column (i.e Tuesday, September
26, 2006 ) and the program write the rest of the dates all the way ...

I am trying to make a workbook that is quite functional in Windows XP
Excel work on Tiger OSX  Excel 2004 - with great difficultly. I got rid
of the ActiveX stuff (I think) - am trying to make a simple lookup work
- ie identify a value in a worksheet and return the value of the next

I have an address list that has a ton of duplicates.  How do I, with
essentially one command, get rid of all the duplicates?
Thanks
Grantman

some files I get open in Excel X with a grey line (no border) below the
first row. More importantly: that row doesn't scroll, so you always have
your column headings in view.
How do I do that with my own files?

I'm using Mac OS X Version 10.4.4 and running Office v.X.
Since this upgrade, I am unable to save a new Excel workbook. On
clicking "Save As" Excel quits immediately, with no error message.  On
reopening Excel, my unsaved workbook reappears, but I am still unable

I'm trying to use an excel add-in from work which was developed on
windows office 97. It works correctly in windows, but when I try to
install it on my mac I get the following error:
Compile error: Can't find project or library.

Hopefully, someone has seen this & knows a work-around - it's making me
crazy. I don't have a lot of experience writing VBA code for this
platform.
I'm developing a set of macros (on Win/XP) and testing them on Macs.

Recently Bernard Ray helped with the code below where all three VBA toolbars
are on view when the VBA editor is opened
Can that code be extended so the Properties window does not open?
Even better, can the Projects window be moved to a position to the right of

Dear members:
Some of you here may not be old enough or remember but in the mid 80's when
Lotus 123 was the dominating spreadsheet on PCs running DOS there was a
competing spreadsheet application named "Lucid 3D". It had an interesting

I navigate from cell to cell with the keyboard arrow keys. What
keyboard shortcut/command can I use to activate/place the cursor in the
formula bar, so I can then navigate through text in the formula bar
using the arrow keys? (i.e. It is a hassle to take my hand off the

How do I turn off the "Error Checking Options" Smart Button, in Excel?
I never needed that function in the last 15 years, and now, it's driving
me crazy!
Thanks,

I am and old user of Mac and work very much with excel. The excel
version that I used in my previous ibook worked much better than this,
and so does the excel in PC. I looked in get info to increase the
memory asigned to excel, like usually, but it seems that Tiger does it