| Thread | Last Post | Replies |
|
| Screen flickering !!! Help | 18 Jan 2007 14:13 GMT | 3 |
am using the following code to pull information from a sheet and paste into another, wanted to stop the screen updating as the macro runs and have applied the Application.ScreenUpdating = False - even though this is here it is
|
| several data colums into one personell rooster | 18 Jan 2007 13:35 GMT | 3 |
I'm trying to create a personell rooster chart with a 6 week cycle. The workbook I have looks like this: a: date b: day
|
| Workbook loads but does not display | 18 Jan 2007 08:53 GMT | 2 |
This is a weird one. Excel 2003 SP2 running on XP Pro SP2 in a SBS 2003 SP1 environment. If Excel is closed and you double-click on an Excel document, the workbook does not display. There is just a big, empty grey window. Status bar says
|
| How should I calculate elasticity by using excel? | 18 Jan 2007 05:11 GMT | 11 |
I want to calculate elasticity of expenditure (by households) in education with respect to increase in income. Pls help me. I have huge data set from household survey Yam
|
| How do I find the highest number(s) in a column? | 18 Jan 2007 03:10 GMT | 5 |
I have a datebase containing 2 columns. In one column I have 105 individuals names in the other column is a number associated with each name. I would like to search the column with numbers and find the highest number and the person(s) name associated with that number and then ...
|
| Help creating an Excel Add-in using VS205 in either VB.NET or C# | 18 Jan 2007 01:08 GMT | 1 |
Hi there, I know that what I'm asking is relatively simple so I would appreciate any help I could get. I want to create an Excel Add-in but I don't want to use VBA. The reason is that I want to hide my code. So what I would like to do is to create an Excel Addin using VS 2005 in ...
|
| Excel 2007 weird formatting issues | 17 Jan 2007 23:22 GMT | 6 |
Does anyone here use Excel 2007 already? I began using it and when I tried to do my favorite border with dropped shadow, there was no longer such option in Excel 2007. Instead I can choose to create a rectangle box (Inser -> Illustrations -> Shapes ->
|
| Solver - multiple solutions | 17 Jan 2007 23:12 GMT | 1 |
I am working on a table that has ratings from G5:G55, and percent payouts based on those raitngs in cells H5:H55. I want to be able to run something (solver maybe), that will fill in the cells in column H until cell G58 (which tells me I'm out of money) hits zero. The
|
| adding times | 17 Jan 2007 22:29 GMT | 3 |
I have a timesheet and I need a formula that will ADD the following times: 1.67 1.11
|
| Metadata and Fingerprinting | 17 Jan 2007 20:47 GMT | 2 |
I work at a law firm and we have an attorney that has received an Excel file from an attorney on the other side of the case. There is some question as to the validity of the data in the Excel file and it's possible it's different from the original that we don't have access to. ...
|
| How to repeat same layout | 17 Jan 2007 18:09 GMT | 2 |
I am making up new resident lists for our Security gates at a residential community. Is it possible to save the layout width of the columns I want to use, which is only columns A thru F. I will have approximately 40 different street address lists when I am done. I have taken ...
|
| How to create a formula that results in a blank cell if required | 17 Jan 2007 16:55 GMT | 7 |
I have a spreadsheet that is to be populated during the course of the year. I have a column which totals the number of days worked on a particular task and have copied the formula down the sheet for the number of entries required.
|
| crash on conditional sum wizard | 17 Jan 2007 16:06 GMT | 1 |
I can think of no reason why Excel (2002) suddenly has decided to exit (even wihtout asking to save te current workbooks!) every time I ry to use the conditional sum wizard. I have tried to uninstall he add-ins, then run excel, op en workbook, close
|
| Change the formatting of row by select a single cell & Editing should be working | 17 Jan 2007 13:46 GMT | 1 |
Hi All; I require such a sheet code which can help me in Changing the formatting of row (like A1:A25) of selected cell (A4 is Selected) and allow me to use editing (Cut, Copy, Paste, Undo etc).
|
| Formattinb cells | 17 Jan 2007 06:11 GMT | 4 |
Is it possible to change the background color of a column of cells depending on the value of the cell at the top of the column. I have written a macro to do this but can't find a statement to do this:
|