| Thread | Last Post | Replies |
|
| Find/Replace changes cell format ?????? | 23 Jan 2008 10:08 GMT | 2 |
I have a column in spreadsheet containing codes - they are 4-digit numbers some of them contain leading zeros. So column is formatted as Text to preserve
|
| worksheet_save macro help | 23 Jan 2008 09:49 GMT | 5 |
My worksheet contains worksheet_change event based on range name "ID". What i want is when i save or close the workbook i want ID = "". I have written the following code Private Sub Worksheet_save()
|
| Double variable value in excel | 23 Jan 2008 08:52 GMT | 1 |
I had a question about how the double variable is used in excel. When I program in C++ and I assign x = 2; where x is a double the actual value is 1.999999999 or 2.000000011 but in excel it is exactly the number you assign
|
| Formula Help | 23 Jan 2008 08:49 GMT | 1 |
I need some help with a formula......... When an amount is equal to or greater than negative 2.50 i need the outcome to say 0. When the amount falls into one of the other categories i need the outcome to correspond to the correct dollar amount below.
|
| Making selected cells more visible | 23 Jan 2008 08:46 GMT | 3 |
In Excel 2007, among the many new things I'm trying to get used to is the faint highlighting of selected cells. If I select a cell, or a range of cells, Excel highlights the selection as it always has. But the contrast between those highlighted cells and the unselected cells is ...
|
| Data | 23 Jan 2008 08:41 GMT | 1 |
When I program in C++ a variabl declared as a double x = 2.0 comes out as 2.0000001 or 1.99999999 but in excel it is 2.0 exactly why is that?
|
| loan amortization schedule | 23 Jan 2008 06:28 GMT | 6 |
Hi, I have the loan amortization schedule loaded & am using it to amortise equipment (so it may be the wrong template to use???). I need to enter in a balloon payment for the final payment but it's not calculating how I want it to, can anyone give some advice on setting up a ...
|
| Possible to change/update values in range of cells by X% ? | 23 Jan 2008 05:54 GMT | 2 |
Is it possible to update or change the values in a range of cells by a certain percentage? What I'm trying to do is apply a 10% increase to a column of prices (several hundred cells long) without doing it manually one by one or creating a new column (B) that references the values ...
|
| This should be easy - Part 2 | 23 Jan 2008 05:53 GMT | 1 |
Sorry, I wasn't able to post a reply to my earlier theread, so I had to start a new topic... Here is my spreadsheet: ---Date Range---
|
| This should be easy... part 2 | 23 Jan 2008 05:53 GMT | 1 |
Sorry, but this site would not let me post a reply to my earlier thread, so I had to start a new one... Here is my spreadsheet: ---Date Range---
|
| formula to pull names out of list | 23 Jan 2008 05:30 GMT | 3 |
If I have a column of names (BUT the names are repeated) in a listed and I want to have a formula that pulls out each name 1 time and puts it in a list on a different sheet how do I do this. Example WorkSheet 1
|
| Worksheet Tab Names | 23 Jan 2008 04:50 GMT | 1 |
I have a workbook with 16 sheets. I want the Sheet Names (Tab Names) to reflect data on Sheet 1 in various cells. Example Sheet 2 name will reference Sheet 1 Cell B3, Sheet 3 name will reference Sheet 1 Cell C3, Sheet 4 name will reference Sheet 1 Cell D3. Sheet 5 name will ...
|
| Pivot Tables | 23 Jan 2008 04:07 GMT | 1 |
I have a source sheet that has several columns in it (see below). The column for RC can have a number in it from 0-23. When I create a pivot table with this data (see below), it throws RC in whatever order it wants. I would like the legend to read in numeric order. Any help ...
|
| VB code for running a macro | 23 Jan 2008 02:53 GMT | 3 |
I'm trying to write a couple lines of code for a macro, call it Macro1. I want Macro1 to be able to run Macro2. What's the code command for that? Thanks, rcc
|
| Password Protect Macro - Compile Error | 23 Jan 2008 02:50 GMT | 1 |
Please help me to discover what is wrong with this excerpt from a macro that I am writing to protect a sheet in my workbook with a password. I keep getting the compile error message. __________________________________________________
|