| Thread | Last Post | Replies |
|
| Find a character in a textstring | 28 Sep 2006 17:56 GMT | 2 |
I would like to find a character (in my case the letter S) in a list of textstrings, and then return the textstrings containing "S" , as well as the two other columns that correspond to it .
|
| Excel + user input + external data (URL manipulation) | 28 Sep 2006 17:48 GMT | 2 |
Is there any way for excel to manipulate the values sent with the external data (URL) request? Here's the basic concept: - User opens survey excel file on their desktop.
|
| duplicate text | 28 Sep 2006 17:37 GMT | 4 |
How do you find duplicate text entries using conditional formatting? All information is geared towards number format. I have names (all in one col) that I would like to find out if they are duplicated...
|
| Excell 2003 | 28 Sep 2006 17:22 GMT | 1 |
[1] How does one show negative numbers in red color? [2] How does one "paint" cells/fields?
|
| Merged Cells in Worksheet, Test for | 28 Sep 2006 17:09 GMT | 2 |
XL 2003 Simple way to test for existence of any merged cells in worksheet. Must it be a cell by cell evaluation OR [Each myCell in myRange] is there a "merged state" that is reflected on a Sheet basis?
|
| Macro prompt | 28 Sep 2006 17:03 GMT | 2 |
I have a macro that creates a new worksheet, deletes 2 tabs, then closes the worksheet. When I run the macro there are 2 prompts, 1-do you want to delete the sheets
|
| uppercase | 28 Sep 2006 16:59 GMT | 1 |
is there a way to convert all data in a range to uppercase and also make it so all future entries are in uppercase?
|
| An if question | 28 Sep 2006 16:53 GMT | 2 |
Hi I have in a row 3 different values that I want to compare with a specific value on the same row. It looks like below A B C D 10 20 30 22
|
| Excel workbook is corrupted, workbook automatically saves on start | 28 Sep 2006 16:51 GMT | 3 |
I have a group of users whos speadsheets seem to get corrupted quite often. The offending sheets cannot be opened in excel, it hangs at the start of opening the file,cpu goes upto 100% and just sits there almost like its in a loop.
|
| Password a Macro so certain users can press it | 28 Sep 2006 16:44 GMT | 2 |
I have a cell on my worksheet which is protected via the usual password protect worsheet thing. However, i want to allow one person to write in this cell my pressing a macro which allows him to do this, then lock again after if possible? Anyone any ideas?
|
| How do I turn off the automatic Format Painter? | 28 Sep 2006 16:36 GMT | 2 |
This stupid little "PaintBrush" keeps popping up and blocking the cells I am trying to work with. It is more annoying than the "automatic" mulitple copy clipboard because it actually sits on top of what I am working with, blocking it from my view.
|
| Dropdown from a Dropdown | 28 Sep 2006 16:00 GMT | 1 |
I am trying to create a dropdown menu that is dependent on another dropdown that I have already created. The simplest way I can think to illustrate this is to give the following example:
|
| Bulk change cells to Array Formula | 28 Sep 2006 15:59 GMT | 1 |
I have a sheet with several hundred cells which are filled with array forumlas. The problem is that none of the formulas have been entered by using CRTL-SHIFT-ENTER. Does anyone know of a VBA function which can be used to set all of these cells to Array forumlas?
|
| How do print only the used portion of an excel spreadsheet? | 28 Sep 2006 15:55 GMT | 1 |
Unless I request printing a specific number on pages only, my printer will print 1200 pages, even thought my file is only 5 pages long.
|
| Formatting a formula within a cell | 28 Sep 2006 15:49 GMT | 4 |
I am trying to use a formula and text within the same cell but I want the value of the formula to have a currency format. Can this be done? I have even tried to use a separate sell to calculate the formula to give me a currency value and then input the value of the cell into the ...
|