| Thread | Last Post | Replies |
|
| Recover deleted excel-files on usb-stick | 31 Aug 2008 22:45 GMT | 9 |
I accidently deleted an usb-stick with lots of important excel-files. Has anyone by experience managed to undelete and recover them and cab give me the name of an undelete/recover program. I already tried a lot of them, but none of them did the job (or seems to can do the job for ...
|
| "Not Responding" for HOURS | 31 Aug 2008 21:14 GMT | 1 |
My Excel 2007 spreadsheet has been "Not Responding" for HOURS. I can hear the hard drive spinning (at various speeds) but, on the PC, the green activity light (indicating that data is being written to or read from the hard drive) has been flashing very infrequently.
|
| AVERAGE formula with a twist | 31 Aug 2008 20:29 GMT | 5 |
I need to average a range of cells B2:Y31. Normally, I'd use the formula =AVERAGE(B2:Y31)... easy enough. The twist is that I need to average that range of cells, BUT any cell that has a value less than 1 or more than 900 cannot be used in the calculation.
|
| List of worksheets | 31 Aug 2008 19:01 GMT | 9 |
In a workbook with multiple worksheets, each with a unique name, how would I create a list of of the worksheets? In addition, I'd like to be able to show totals from each sheet beside the sheet's name.
|
| Can I make gray scale charts? | 31 Aug 2008 17:26 GMT | 1 |
I have a series of pie charts and bar charts. Is there anyway to get them in black and white instead of color?
|
| Formula prob - or is it validation? | 31 Aug 2008 16:39 GMT | 6 |
In cell A1 I have created a list with options - 1st quarter results, 2nd quarter results, 3rd quarter results, 4th quarter results. Cells A2, A3 & A4 are for the months of the quarter. If I select "1st quarter in A1", I want A2 to read "Jan", A3 to read "Feb",
|
| Starting Excel Impossible | 31 Aug 2008 16:06 GMT | 2 |
It is impossible to open Excel, because of this message: In a Message Box "Microsoft Visual Basic", it is said: "System Error &H80004005 (-2147467259). Unspecified Error" What can I do?
|
| Euro symbol | 31 Aug 2008 12:51 GMT | 5 |
I have a spreadsheet and I have formatted the cells to give me the euro symbol (previously uk sterling) so that is ok. However within the spreadsheet I have a text box, how do I get the euro symbol within it?
|
| Date in CAPS | 31 Aug 2008 04:28 GMT | 3 |
I've got a cell with a date that the user types in. Currently, the user types a date in and it automatically changes the format to DDMMMYYYY. I need the MMM to be in all caps so that it feeds a SQL string
|
| Select All question | 31 Aug 2008 03:53 GMT | 4 |
At home I have Excel 2002 and am very happy with it. At work, I have Excel 2003, and I find it disconcerting that, when I hit a Ctrl + A, it selects a range of its own choosing, within the work I am most currently on. When I say Select All, I mean Select All - is there some ...
|
| Compare columns | 31 Aug 2008 03:46 GMT | 2 |
How do I determine whether the data in COL A exists COL B? How do I determine whether the data in COL A does NOT exist in COL B?
|
| how to fix starting point when counting rows? | 30 Aug 2008 20:37 GMT | 4 |
is there a way to feed in the the starting cell to begin from when counting the number of rows? i can get the below to work in a macro Dim countRows
|
| Date Format | 30 Aug 2008 19:42 GMT | 5 |
I would like to convert a date that I've input from another program. When I input it I get 'Aug-28-2008. I want it to just be a regular date - so it would be *8/28/2008 if I were to select it in Format Cells. It says that I have General as the Category selected. When I switch ...
|
| VBA; Escaping a 'For Next' loop question | 30 Aug 2008 19:24 GMT | 8 |
I have some code which uses a For Next loop which works very well with a very large set of 'Regular Expression' statements. I'm sure when the code is run, it would be a bit quicker if it could go back to 'For' when the value of 'valid' is True rather than
|
| Exclusion List for Data Validation?? | 30 Aug 2008 18:07 GMT | 1 |
I have cells that require an entry (last names of people), so I have the validation set up for text >1 and <1000. This is good if the user decides to leave it blank, but if they put in a space, or two spaces, or more, or put in words like "none" "N/A"
|