| Thread | Last Post | Replies |
|
| How to make a MsgBox appear in or near bottom right corner? | 10 Jun 2007 20:53 GMT | 1 |
Is there any way I can make a MsgBox open up in the bottom-right corner, or some other location, instead of the center of the sheet? Thanks, Russ
|
| "conditional formatting" "#values" | 10 Jun 2007 19:32 GMT | 4 |
I have a formula that works fine but... some of the cells show #values, what i would like to do is conditional formatting them to white font if = #values. Any pointers?
|
| Page Breaks And Merged Cells | 10 Jun 2007 17:55 GMT | 3 |
In Excel 2003, I have a table in which the cells in Column A and Column C are merged in groups of two rows each. For example, Cells A4 and A5 are merged together, C4 and C5 are merged together, A6 and A7 are merged together, C6 and C7 are merged together, etc. The cells in ...
|
| grouping rows... | 10 Jun 2007 17:44 GMT | 5 |
say: DEPT1 EMP1 DEPT1 EMP2 DEPT1 EMP3
|
| How to Execute a Macro to Go to one row down after GOTO command | 10 Jun 2007 17:26 GMT | 4 |
Simple Macro which take me to the last cell on a tab sheet titled "Personal". This is a database that I can add names and telephone numbers. The macro ends with my cursor on the last cell of a the two column worksheet (Column A & B) which in this case is column B. I want to ...
|
| 'flashing' | 10 Jun 2007 16:57 GMT | 3 |
I have some macros (sample below) I have a button to run. Since it copy's each cell from one worksheet to the other, about (10 items) the sheets flick back and forth as the macro runs, so looks like a flicking screen, could cause problems etc, how can I make it so
|
| quick acces tool bar | 10 Jun 2007 16:14 GMT | 5 |
How do I add text to the icons ?
|
| Converting form data to neutral numbers or text? | 10 Jun 2007 15:13 GMT | 3 |
I have an Excel '02 project with a lot of form data stemming from both other work sheets and other excel files. I now wish to convert the calculated data to neutral values in a heck of a lot of cells.
|
| Suppliers Excel Sheets | 10 Jun 2007 13:13 GMT | 1 |
I have several locations need deliver products. I must build a list of my locations? (Excel 2003) Delivery Title, Location Name, Address, District, City, State, Country And ask suppliers to deliver.
|
| How to view Header or Footer on screen in Excel | 10 Jun 2007 12:42 GMT | 6 |
I would liek to know if there is any way of being able to view the header and/or footer in an Excel document on screen?
|
| email address withour hyperlink | 10 Jun 2007 08:16 GMT | 3 |
How can I enter an email address into an Excel spreadsheet and stop it becoming automatically hyperlinked? Robin Chapple
|
| Help defining a user-defined function | 10 Jun 2007 07:46 GMT | 7 |
In Excel 2000, I need to create a user-defined function to execute an exponential formula with 4 parameters: Xa, Ya, Yb, & h. The formula is: y = Yb + (Ya-Yb) * exp( (ln(2)/h) * (X-Xa) )
|
| Formula for date field | 10 Jun 2007 00:49 GMT | 6 |
1.I have simple dates in one column (say column A) . 2.In the next column(Column B) I would like the date five months after Column A to be displayed.Eg if Column A has an entry of 9th June 2007,Column B should display 8th November,2007.
|
| I do not know how to get my gridlines to stay | 09 Jun 2007 22:47 GMT | 3 |
Oh my I have no idea why I lose my gridlines. I start out with them rthen I hit print preview and they dissapear. Where do I find out how to use excel, kindergarden instructions. Lynn
|
| formula construction | 09 Jun 2007 20:12 GMT | 7 |
Some people use only the = sign and some use =+ why would one want to put a + sign infront of a value? Does this force negative values to positive?
 Signature Regards
|