Mac Forum / Applications / Excel / May 2008

I am trying to use a text string in a select case statement in VBA. To
wit:
Select Case test_string
       Case Is = "first header"

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Thanks for the last answer now another one please
Like I said I just got the 2008 version, is Sumproduct in the Add Ins.

Excel 2004.
Mac OS X 10.4
I am getting inconsistent and incorrect results using SUMIF.
I have a spreadsheet with a column of dates. I use the MONTH function to

Version: 2004
Operating System: Mac OS X 10.5 (Leopard)
I would like to change the color of the highlighted cell (shows you which cell you are currently at/working in) The outline color is light blue and I need it to stand out more. I am not talking about highlighting an individual ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Hi all new to the 2008 excel.
How do I get the results in my Table to change color based of their value (i know in 2004 how to do it). But i am seeing on the images on some sites that excel will even insert arrows based on the ...

Operating System: Mac OS X 10.4 (Tiger)
I am using "Excel for Mac" on a MAC mini, having recently switched over from PC. I have a large number of files created with the Works data base and, while I am fairly familiar with PC, I am new to the excel spread sheet.
I wish to display ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I've just started reviewing a workbook given to me by one of my clients, and it gives the standard "can't find links" message when the file opens. I'd like to see which cells in the worksheets (there are about ...

Hello. An easily answered question, I hope: I want to increase the size of a
row in my Excel 2003 spreadsheet, but when I place the cursor on the line
separating it from the row below it, it no longer changes to the shape
enabling me to drag the bottom line of the row to where I ...

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
I have changed the system preferences to UK Pound stirling however the xl currency changes my pound sign back to a dollar sign everytime I re-open ther spreadsheet?

When opening an existing excel spreadsheet, which is then maximized using the mac green window button, Excel crashes, taking with it all control of OS X. I cannot tab between windows, cannot force quit of the hung excel app, cannot regain control and does not time out and return. ...

In excel 2003, when I created a bar chart, I was able to change the fill in
the individual bars from solid to cross hatch or dots, a useful featue when
trying to display temporary, preliminary or revised information.
I recently upgraded to excel 2007 and cannot find this feature.  ...

Hi, I am trying to incorporate my actual error bars into a bar graph using excel 2008. In the 2004 version, you could highlight the spreadsheet cells containing the errors for each data point and add it into the Y error bars category. I am unable to do this. Is there any way that ...

Version: 2004
Operating System: Mac OS X 10.4 (Tiger)
Processor: intel
I have a complicated excel system using macros in excel.

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
In Excel for Mac when I move to a cell, the color surrounding it is a very light blue. It is very hard to see. Is there a way I can change it to another color?

Each time I open an EXCEL workbook in Office 2003, i get this message:
"System Error. H80004005 (-2147467259). Unspecified error" and then
"Compile error in hidden module. Thisworkbook"
Is there an easy way of rectifying this, please?