Mac Forum / Applications / Excel / March 2005

I've been an Excel VBA developer for nearly a decade. I developed shareware
for many years, for both PC and Mac. I was also a beta tester of Excel 2001,
Excel X and Excel 2004 for Mac. And I was given the MS MVP (Mac) in 2002.
After working with the Mac Excel 2004 for some time, I ...

In a cell out of the range:
=COUNTA(F6:F13,"")
=COUNTA(F6:F13,"=""")
=COUNTA(F6:F13,"<>''")

when I try to run my macro I have recorded before I get message "Copy
method of range class failed"; it is just simple
Range("B1:B10").Select
   Selection.Copy

the following code returns predictable results:
tell application "Microsoft Excel"
 set theSelection to (get selection)
 set theSelectedRange to (item 1 of (get areas of (get properties of

I've gotten this far:
tell application "Microsoft Excel"
 try
   set theProps to (properties of used range of sheet 1 of active

Hey guys, I was trying to link my excel spread sheets to a powerpoint
presentation so that changes in excel would be reflected on the graphs in my
Powerpoint slides. I'm not exactly sure how to do that. Do I have to save it
in a certain way or import the information in?

It appears that the new update Office 2004 1.1.1 Still doesn't cure the issue
of not being able to tab through VBA dialog boxes !!! When will someone
realise this is quite a major fault

Sometime it happens you look over a Excel for Windows User: I saw
colored worksheet tabs. I did not ask the user how to change the
color.
At home I right-clicked on the tab  in Excel 2004 - no option to

I'm having trouble with a huge spreadsheet that I'm working with. It's
a database of names and addresses, and all of it is in capital letters.
Is there a way to apply the 'PROPER' command to the whole spreadsheet?
Or any other ideas???

I'm writing a macro in which I need to print out a variable range. One
day it could be from A1:F10, the other dat from A1:F200. If I try to
incorporate the
Range(Range("a1"), Range("a1").End(xlToRight).End(xlDown)) method, it

I have had a look both here and in the documentation, and I cannot see  
what may have changed between Office vX and Office 2004 with regard to  
number formatting in cells.
Basically, I 'used' to be able to enter a number in a cell with a format  

I tried to open an important file this morning on excel and instead of
opening it properly, it opened the file as a text document. The little
opening box reads "Text Opening "file name" and then shows me a bunch
of random computer language in the workbook. The file was working fine

Can COUNTIF look for different text values in a particular string?  Students
taking a quiz can choose from 4 options. Two of those options are
acceptable. They could pick "30 minutes" or "1 hour" but not "5 minutes" or
"4 hours". I'd like to tally their correct answers with ...

I'm a PC user sending Excel 2002 workbooks to a client.  He only sees
the first worksheet and cannot open the other worksheets within the
workbook.  Is there a secret to being able to see the other worksheets
within a workbook in the MAC 2004 version?  I have tabs for each

this is a bit of a newbie question, but ... :
every time my macro ends (I launch it by clicking on a button), the
editor window of Visual Basic Editor appears on the foreground ...
could I avoid this ?