| Thread | Last Post | Replies |
|
| Run Macro If Cell value = "Other" | 20 Nov 2006 09:42 GMT | 1 |
Alright, I have a very simple macro at the moment that unhides a column and adjusts the print area to suit. What I need is a maco that will run this macro if the cell F4 = "Other" from a drop down menu.
|
| Force user to enter data in cell before moving to next cell | 19 Nov 2006 23:49 GMT | 3 |
I would like some help- I have designed a form were information needs to be entered in certain cells, how can I force users into inputting this data and not skipping cells
|
| help help help IF function | 19 Nov 2006 23:18 GMT | 3 |
i am new to excell and need help with a problem...... the problem is iam looking for a amount < = 3000.00 and iam to display in bold and in light green i have never had to deal with that i got as far as =IF<=3000 then iam lost or it that even right??
|
| Viewing Built-in Code | 19 Nov 2006 23:14 GMT | 4 |
How do I view the code for a built-in macro? Specifically, I want to see the code for "next sheet" and "previous sheet" (Crtl-PageUp & Ctrl-PageDown Thanks in advance for your help.
|
| Weird date formatting | 19 Nov 2006 22:47 GMT | 5 |
I am brand new to Excel and am having trouble formatting a date. We have different nationalities in the office where each person enters the date differently: * month, day, year
|
| I want to show message/mail form? | 19 Nov 2006 19:34 GMT | 1 |
I use Outlook Express. I wanna make the app which can show message/mail form. When User click a button, so message/mail form will show with its Recipients, Subject, Attachments, body has filled automatically. if i just exec/run 'mailto:a@a.com', So I only see message/mail form with
|
| How do I get all cells both column and rows to print? | 19 Nov 2006 18:06 GMT | 2 |
I am designing a Excel worksheet that will enable me to input data each day throughout the month. I would like to print both the column lines and the row lines. How do I go about it? Is this possible?
|
| Stock Card Data Base | 19 Nov 2006 17:23 GMT | 1 |
I have over 15000 stock cards and wish to colate some of the information onto one stock sheet, with auto update from the stock sheet. How can i do this Thanks
|
| Excel will not open..if file clicked | 19 Nov 2006 17:22 GMT | 1 |
Ok maybe I am missing something simple but this is driving me nuts... 1. I receive an email with an Excel attachment Using Oultlook express and windows XP Office I click on attachamnet and get a pop up saying that the
|
| Totalling Columns | 19 Nov 2006 12:48 GMT | 4 |
I have two columns of figures B2:B22 and C2:C22. I have merged cells B23 and C23 and want to have figure Column C minus Column B showing in this cell. No matter what form I take I can't achieve this. Can anyone help, please.
|
| Does any one know method "checkDeletedRows"? | 19 Nov 2006 12:37 GMT | 2 |
Does anyone know method "checkDeletedRows" in VBA? I have two ranges from two sheets and I need to find the row from rang B that doesn't contain in rang A according to the value in column A of both ranges ("the value is "ID")
|
| "Ignore Blank" ignored while validating | 19 Nov 2006 12:23 GMT | 3 |
I have defind a list via Insert > Name. If I validate a cell via Data > Validation and choose list, list name, I still have emty value in the combo box while the toggle "Ignore Empty" was active. Bart
|
| Define whether to use list 1 or 2 | 19 Nov 2006 12:14 GMT | 2 |
I do have three Insert > Name > Define > lists created on one worksheet. How to have either one of the 1st two list activated on a cell when the neighboring cell a value is choosen from the 3rd list list?
|
| How to convert fraction format to text format ...... | 19 Nov 2006 01:19 GMT | 3 |
...... and still shows the fraction instead of decimals? I have formatted a range of cells to fraction. Then I key in the following values:- 1/2 1/5
|
| Headers? | 18 Nov 2006 23:06 GMT | 1 |
Is it possible to rename the column designations? So instead of having A, B, C and so on, you could rename then to whatever that column is for?
 Signature Sincerely
|