| Thread | Last Post | Replies |
|
| latest date | 19 Sep 2007 13:09 GMT | 5 |
help need hi i have a list of disconnection customer. in that list the disconnection date is repeated. means disconnection is made more than 2 time. it is difficult to
|
| Setting up an If-Then condition off of a command box | 19 Sep 2007 10:22 GMT | 1 |
I am trying to set up a command box that will do two things conditionally if clicked. First, I want to run a macro that will validate that text is present in a range of cells (all cells must have text values, although the text values may vary). If all of the cells in the range ...
|
| rngDataAll, rngEnd, rngStart, etc | 19 Sep 2007 09:06 GMT | 3 |
I have come across these values rngDataAll, rngEnd, rngStart, etc used with a range object thus: Range("rngEnd") It is self-evident what they mean but where are they defined?
|
| Spreadsheet of seven types of items | 19 Sep 2007 08:11 GMT | 1 |
The first item will be the date. The second item will be purpose in text. The third, fourth, fifth, and sixth items will be numerical data. The seventh item will be numerical data.
|
| Getting a pictures height, width before setting it in Shapes.AddPicture | 19 Sep 2007 05:54 GMT | 1 |
I'm inserting several images into a worksheet however these images are rather large. Therefore rather than doing Worksheets(1).Range("A1").Select()
|
| Changing this formula? | 19 Sep 2007 02:04 GMT | 8 |
=IF(L2<>"",IF(M2=0,"OKAY!",IF(M2<>0,"RE-VERITY (or M1 needs a value in it!)!!!","")),"") I'm stuck and am probably going 'round in loops, but I need to add one more condition. If L2 is blank, there needs to be no text.
|
| Splitting one cell into three. | 19 Sep 2007 00:23 GMT | 2 |
Try to split a cell in Excel 2000. in one excel cell the following information is recorded. .032 x 6 x 12.5 2024-t3 clad If I can pull out the information .032, 6, and 12.5 to three separate
|
| Position in a list of numbers | 19 Sep 2007 00:16 GMT | 3 |
Hello, I hope someone can help me. Is there a function (or a combination of function) to let me know in which position of a list is a specific number? For example, I have this list of numbers
|
| Excel 2007 crash on save | 18 Sep 2007 22:46 GMT | 6 |
I have several users, albeit not all, who are experiencing problems with Excel 2007 crashing during a manual save. Windows XP on all machines. So far it is only desktops, so the Bluetooth Com+ add-in is not an issue. These are spreadsheets that were created in Office 2003, so ...
|
| How can you make cells bold or shaded no matter what gets moved into it? | 18 Sep 2007 20:10 GMT | 2 |
I have a few different cells in my Excel spreadsheet that I want to always be bold or shaded red no matter what is in these cells. I have some data that I sort and always want the top to be bold and shaded red. And of course when I sort the data and the top data that was bold and ...
|
| Limiting Decimal Entry | 18 Sep 2007 19:25 GMT | 5 |
Does anyone know if there is a way for me to limit the number of decimals entered into a cell to 2? I don't want to truncate or round the entries. It doesn't matter if an error message is raised, I just want to set a hard limit.
|
| data validation box arrow | 18 Sep 2007 19:25 GMT | 2 |
Excel 2002 SP3 Win XP HE Hi, On a data validation cell using the drop down list, is it possible to
|
| Difficult formula... | 18 Sep 2007 19:22 GMT | 2 |
I'm having a heckuva time figuring out a formula. There's gotta be an easy way to do this. Here's my data: ================================================== A B C D
|
| I need a list of my tabs! | 18 Sep 2007 19:10 GMT | 2 |
I have a project in Excel that has about 300 tabs. Is there a way that I can get a list of the tabs only?
 Signature ~Christina
|
| "screen shot" of formula results. | 18 Sep 2007 18:56 GMT | 2 |
I'd like to "unlink" a spreadsheet from the formula's. I have a spreadsheet that references other spreadsheets but I'd like to break all the links at once. Is there a way to do this?
|