| Thread | Last Post | Replies |
|
| Cannot open an e-mailed Excel document | 28 Dec 2004 20:31 GMT | 1 |
Have Office 2003 - all current updates as per website, cannot open e-mailed Excel spreadsheets/lists/documents?
|
| Odd 'automatic' formula behavior | 28 Dec 2004 20:07 GMT | 2 |
I have a user on Windows 2000 Office 2000 SP3. The formula in question is =SUM(B4:E4) and it is in cell H4. Columns F and G are normally blank and this is by design. Seemingly at random, when information is entered into either column F or G
|
| help | 28 Dec 2004 18:57 GMT | 2 |
How to use a macro to recalcutate a invoice number, for instant 0001 to 0002 automatical For a college course Dave
|
| Rows Autofit | 28 Dec 2004 18:44 GMT | 1 |
I try to set autofit for rows but got error lastrow = ActiveSheet.Cells(Rows.Count, 1).End(xlUp).row rows("2:lastrow").autofit
|
| Un-assign a macro | 28 Dec 2004 17:43 GMT | 2 |
This is not obvious to me! How do you un-assign a macro from a picture? I wish to keep the macro, and the picture, but remove the assignation. Any help?
|
| Mirror/Clone/Synchronize Cells | 28 Dec 2004 15:24 GMT | 2 |
Does anyone know if there's a way to connect multiple cells so that when a cell is modified all connected cells mirror this new value? I need something more than the one-way source-destination propogation with the link function.
|
| Password For Folder | 28 Dec 2004 14:02 GMT | 1 |
Dear Friends , I know this is Excel Group , although i am seeking the help from you regarding , putting password to folder , without adding it to ZIP. Is there any option for setting the same in Windows XP Proffesional Operating System.
|
| Errors were detected in file name.xls | 28 Dec 2004 12:43 GMT | 1 |
Error: Errors were detected in file name.xls, but Microsoft Excel was able to open the file by making the repairs listed below. Save the file to make these repairs permanent.Translation:
|
| Data Format: how can I re-format | 28 Dec 2004 06:21 GMT | 2 |
The spreadsheet that was exported for me to use has the information in paragraph form: It is customer ID name and billing info but it is like a long series of address labels.
|
| Excel as database interface ? | 28 Dec 2004 06:04 GMT | 5 |
It is possible to make something like that: On save user saves spreadsheet on HD and data are send to database, next time when they open the file they take data from database instead of fixed data ?
|
| Not deleting headers | 28 Dec 2004 05:39 GMT | 1 |
as an aswer to a previous question I've received the following code: Dim c, sh For Each sh In ThisWorkbook.Sheets If sh.Name <> "Main_Sheet_Name_Here" Then
|
| Link to List Box Entries? | 28 Dec 2004 01:35 GMT | 1 |
Is it possible to do cell links to a list box with multiple selections?
|
| Some kind of "Intersect" function for formula? | 27 Dec 2004 23:37 GMT | 7 |
My understanding of Excel is not the best, so please excuse me if I'm off-track here. I want to use VBA to set and name a range around a certain section of a workbook. I can do that. Then I want to go to the row under the range and set a formula using VBA in each column used by ...
|
| VBA Command to Look at cell in an If statement | 27 Dec 2004 23:28 GMT | 3 |
I need to create a macro in VBA that will look at a specific cell (which contains the result of a lookup formula) in an If statement. Basically it would look at a certian cell, and If that cell had the word "YES", then it would execute a seprate macro. If not, just continue on ...
|
| Tricky Time Calculation | 27 Dec 2004 23:03 GMT | 2 |
Hi, and thanks in advance for light shed on this . . . I have a situation where there are three levels of pay possible, (Regular, Shift Differential 1, and Shift Differential2), where there is one rate for 0:00 - 06:00, another for 06:00 - 18:00, and a third for 18:00 - 24:00. I
|