| Thread | Last Post | Replies |
|
| Calculation speed | 27 Sep 2006 12:15 GMT | 3 |
I have a not hugely complex workbook which I have been running without fuss. Now, on machines upgraded to use Excel 2003, every time you enter a new piece of info it takes up to a minute to calculate whilst the same file is fine on the previous version of Excel. I can turn the ...
|
| Select range in VBA through variabel | 27 Sep 2006 11:58 GMT | 2 |
Hi I try this code, but I will not work. sub selectnamedrange(fblock as Integer) dim frow_string frow_string = "f" & fblock & "_frow"
|
| Converting A Word Table To Excel | 27 Sep 2006 10:46 GMT | 1 |
Hello to all - Is it possible to convert a table created in Word to an Excel spreadsheet? If so, please advise. I have a form that I created in Word that I would like to convert into an
|
| Add text to bar charts | 27 Sep 2006 10:13 GMT | 3 |
have a series of bar charts want to add text to these, can anybody help? The text that I want to add is the same as the legend if that helps thanks in advance
|
| Date and Text combination | 27 Sep 2006 09:17 GMT | 3 |
could someone help me with getting this particular format in ONE SINGLE cell: Text 25-Sep Please note that the date part has to be variable, i.e i shuld be able
|
| Macro to set the row height | 27 Sep 2006 08:52 GMT | 1 |
I need to set the row height depending on the content of a cell. If Cell A1 = "x", I want to set rowheight of A to 50, if A1 = y , then I want to set rowheight of A to 75 I want to repeat this check for 100 rows.
|
| FALSE Statement | 27 Sep 2006 08:33 GMT | 2 |
I have a formula like this K232=IF((J232="A"),-1*I232,IF((J232="B"),I232*F232,IF((J232="C"),0)) If there is nothing on J232 it displays FALSE , I would like to get rid off this FALSE and cell should be blank, i tried IF(J232=""),"" but
|
| Formula - Exam Marksheet | 27 Sep 2006 07:51 GMT | 9 |
Please help me with a formula for my marksheet. The exam grading is A, B, C, D and E. E is a failure To pass the overall exam, a student must :- Must NOT FAIL in any 4 subjects from columns E7, G7, I7 and K7
|
| Recent File List not there | 27 Sep 2006 02:29 GMT | 7 |
In Office Pro/Excel 2000 I have Options set to show the last 9 files used, but lately there have been none showing if I haven't opened Excel for more than a day or two. I never heard of this being time delimited before. Any suggestions?
|
| What is the best work sheet used to calculate monthly expenses? | 26 Sep 2006 23:13 GMT | 1 |
I would like to compare salary against monthly expenses and would like to know if there is such a template available.
|
| Pivot Table Subtotal of Calculated Field Problem | 26 Sep 2006 22:39 GMT | 3 |
I have created a pivot table for the purpose of viewing revenues by sales person, company and project. I am having a problem with the subtotals due to my use of a calcuated field. PLEASE HELP!! Here is the info:
|
| Conditional formatting question? | 26 Sep 2006 21:09 GMT | 3 |
I tried to set two conditional formats across the same range of cells using Format >> Conditional Formatting. I tried to set Formula Is =MAX(U5:AB5), font = red, and Formula Is =MIN(U5:AB5), font = green. The font in all cells turned red! What would be the correct way to do ...
|
| X Y position | 26 Sep 2006 19:55 GMT | 2 |
Can someone confirm that the figures at the end of the code below, relate to the position of where the input box will appear on the screen? I then need to be able to explain to a non techie how that relates to a screen.
|
| If Statement | 26 Sep 2006 19:25 GMT | 3 |
Hi In an If styatement, how would I go about testing to see if a cell contained a text string please - If (E2="*Phone","True","False"), which is what I assumed the syntax was, doesm't work
|
| More than one line in a single cell? | 26 Sep 2006 18:47 GMT | 1 |
How do I enter multiple lines in a single cell in a column? I need more than one line of information to fit it all in a cell of a row in a column. Please help.
|