| Thread | Last Post | Replies |
|
| Exporting modules | 01 Nov 2007 19:58 GMT | 4 |
I am developing a user interface to handle their information stored in Excel 2003. Whenever I have new changes or I have a new version I want to export all modules and then import them into the production Excel file. Is there a way to export programmatically all ...
|
| default template Excel uses at start-up | 01 Nov 2007 18:06 GMT | 3 |
I want to change the default template Excel uses at start-up, to one of my own design. I did a search on Google for the answer, and found the following:- The default templates used by Excel are called Book.xls and Sheet.xls. If
|
| ROUND function syntax question (hopefully simple) | 01 Nov 2007 16:18 GMT | 2 |
I want to round the results of the following formula to a single decimal place. Can anyone tell me the correct syntax to use the ROUND function? Putting all the commas and parentheses in the right place has always been my downfall where long, complicated Excel functions
|
| COUNTIF Formula - Bug? | 01 Nov 2007 16:10 GMT | 5 |
Having a strange problem with a COUNTIF formula. The formula is: =COUNTIF('Day 1 - EEA'!D9:D32,">0:25")+COUNTIF('Day 2 - EEA'! D9:D32,">0:25")+COUNTIF('Day 3 - EEA'!D9:D32,">0:25")+COUNTIF('Day 4 -
|
| Disabled item in Excel 2007 | 01 Nov 2007 14:52 GMT | 3 |
I am sorry to have to ask AGAIN but wheer will I find any item that was disabled by Excell. I would ike to enable that item again. Thanks
|
| Handeling different languages in a workbook | 01 Nov 2007 13:09 GMT | 4 |
Excel 2003, Sp2 Hello, I have a workbook that consists of 3 different sheets. 2 of them contain instructions and diagrams and are "static", i.e. the user
|
| How to set up a "ticked" rows | 01 Nov 2007 09:26 GMT | 8 |
I am an Excel newbie and want to select say 100 rows at various positions down a 5000 row table then copy these to a new sheet. Rather than copy and paste each one I would like to set up a "tick" cell column in each row so that somehow I can then automatically select all the ...
|
| How to put VBA formula in Excel Sheet | 01 Nov 2007 06:58 GMT | 1 |
how can i fix the error for this VBA? Sub PutDate() Range("A1") = "="Date :" & TEXT(TODAY(),"dd-mm-yy")" End Sub
|
| simple math question | 01 Nov 2007 06:31 GMT | 3 |
My Excel is a rather old version but I think the answer to this question would be the same regardless of version. I have two columns of 4 numbers each. Let's call them A1:A4 and B1:B4.
|