Mac Forum / Applications / Excel / February 2006

This is my 1st posting so wondered if you could help. I use the 'increase
font size' button in a custom toolbar but am getting annoyed that the font
sizes it jumps to are ONLY those in the usual 'font size' box, (i.e from 8
to 72 in mainly increments of at LEAST 2). My old PC ...

Hello, i'm a beginner with excel and vba so please excuse me if this
question seems stupid :
I'm using Excel 2004 for mac and VBA 11.0
I would like to grab informations from internet sites but when i'm

Hi, I can't seem to change the decimal (.) to (,). I've tried changing my
region in the international system preferences pane, but nothing has worked.
It works OK even in the dashboard calculator, but not in excel.
Anyone has a clue??

I have a fairly simple bookkeeping spreadsheet that is used to sum up data on
which supplier was paid what, on what invoice and for what material. The
supplier names and the materials are both stored as Data Validation lists for
dropdown menus attached to the appropriate cells. ...

I download a CSV text file generated by one of our hosted web
applications and open it in Excel (Mac 2004, v11.2.0 - PowerBook OSX
10.4.4) : I can find no way to specify character encoding, and it
always seems to choose the wrong encoding, i.e. MacRoman instead of ISO

I am trying (with no luck) to create a formula that will allow me to
calculate the hour difference between different days.  For example: 1pm
yesturday vs 1pm today would equal 24hrs.  Does anyone know how to do this.  
Please help I need it for work.

I'm trying to post information from an excel 2004 VBA macro, everything
works except the POST info is not sent.  GET vars are sent to my web
page just fine, but I need to send a lot more data.  The code works
fine on Windows XP running Office 2003:

Does anyone know how to get a the values of a range in excel 2004 into a
list?
I used to use <set value_range to value of range ³what ever the name of the
range is²> in Excel 2001 but it doesn¹t seem to work in Excel 2004

Earlier today I posted a query regarding my complex spreadsheet and met
with great success on the response, which encourages me to post another
question.
To recap: the spreadsheet consists of 40 worksheets with the majority

I have a fairly complex Excel spreadsheet containing 40 worksheets with
about 7K cells per worksheet.  One set of worksheets within the
spreadsheet summarizes data from others.  It would make formatting
these summary sheets easier if I could automate inserting the worksheet

First time poster
I would like to know if it is possible for the system to trigger the
execution of a VBA Macro with a simple click on an Excel Spread-sheet cell.
What I would like to accomplish is for the system to clear a series of

I have a long list of data imported into one column.  Each record is 13
rows.  I would like to be able to type the first line of any record
into cell B1 and have it find and report the record plus 12 rows
beneath the record into C1:C13.  Any suggestions?

dear mactopia, mac bu and excel dev team,
i'd like to report a bug in excel 2004 that is reproducible on several
machines in our institute.
setup:

The last column on my current worksheet is IV.  How do I add additional
columns and lines to the worksheet.  Thanks

I'm trying to convert a file from Excel X (Mac) to Excel 2003
(Windows).  I copied the file to Windows, without saving it in any
particular format. The file opens OK in Windows, but loses the
worksheet tabs.  I tried setting the Options to show worksheet tabs,