| Thread | Last Post | Replies |
|
| record business mileage | 31 Dec 2004 23:57 GMT | 2 |
I want to know if I can record business mileage using Excel, and separate business miles from personal and commute miles? I want to divide monthly and run a continuing total for the year. This is primarily for the I. R. S. requirements. Thanks
|
| Excel.exe has generated errors | 31 Dec 2004 21:28 GMT | 6 |
I am receiving the following message: ""Excel.exe has generated errors and will be closed by Windows.You will need to restart the program An error log is being created.""
|
| Is amount of text in a cell limited? | 31 Dec 2004 19:38 GMT | 4 |
I have a cell formatted with wrap text. Several columns wide and quite high. When a large amount of text is entered in the cell, excel will not display it all. The cell only appears half full. I have tried cell validation with no success. Is there a limit?
|
| Resetting Check Boxes & Advanced Filter | 31 Dec 2004 18:53 GMT | 2 |
I created a form that uses Check Boxes for the end user to select certain items which in turn generates a TRUE or FALSE output into another cell. I then used ADVANCED FILTER to select the associated rows and copy them to another page in the WORKBOOK.
|
| Seeking help for total worksheet protection | 31 Dec 2004 18:48 GMT | 10 |
The code below cycles through every worksheet and protects it. It then sets the active worksheet back to the first worksheet. For Each WkSht In m_DocExcel.Worksheets WkSht.Protect "mypassword", True, True, True, True
|
| Sendin mail from Excel | 31 Dec 2004 17:39 GMT | 5 |
I found how to send email with attachement using VBA and MS Outlook from Excel but I have no solution for sending or just prepare message with attachement for Thundirbird or Eudora. Anyone knows the soulution ?
|
| Convert Two Columns Data to One Column with Spaces... | 31 Dec 2004 16:38 GMT | 1 |
HELP! I am usually goo on Excel but this one has me stumped. I have various text files which I can import into Excel and the data is in a two colum format like this: AMIDAR Amidar (J)
|
| How do I edit, copy and paste text in excel cells? | 31 Dec 2004 15:52 GMT | 2 |
If I make a typing error, or want to copy a heading to different cell, I find the only option is to delete the contents of the cell and retype elsewhere. Help, please.
|
| Hiding info | 31 Dec 2004 15:49 GMT | 2 |
I have 4 or 5 cells, that are "control" cells. They contain info that other cells will use but I do not want tthem to be seen. I know that to hide it, I have to enter some under custom, in cell format. Would someone please remind me of exactly it is that hides cell contents?
|
| Addin Question | 31 Dec 2004 08:29 GMT | 4 |
Each week we distribute an Excel file that is auto generated from a database and which is several MB in size. I have identified that the size is due to the mass of unused rows and columns and when deleted, the file size is c. 100kb.
|
| Alarm Sound in Excel | 31 Dec 2004 08:05 GMT | 2 |
Is there a way I can use conditional formatting or something else to have a sound (e.g., wav file) play if a value in cell A1 is less than 25? Note: Cell A1 is an unattended update of a stock or bond value, so it changes frequently, and I want to hear a sound if the value goes ...
|
| Data Form Font Size | 31 Dec 2004 07:32 GMT | 1 |
I was wondering if there is something that can increase the font size of the text in the Data Form under Excel. The only way I can do this is by changing the actual pixel setting on a monitor. I tried to use the Zoom feature and it doesn't affect the Data Form. Is there ...
|
| Validation | 31 Dec 2004 02:47 GMT | 2 |
I would like to have a cell on a spreadsheet configured so if a user tries to open the speadsheet without populating a specific cell the worksheet would not save and a msgbox would pop and inform the user that the cell must be populated. Not concerned at the moment of what data ...
|
| vlookup (newbie, STILL) | 31 Dec 2004 01:28 GMT | 6 |
I have =vlookup(h25,g19:h23,2,false) which returns a number when I type a name. How can I reverse this? Basically, I am using MIN in a formula in column B and when I get the result of the MIN formula I would like it to return the corresponding name from column A. I am using cells ...
|
| PLEASE HELP - Invoice number | 30 Dec 2004 22:31 GMT | 2 |
PLEASE! - Can someone please tell me how to make an automatic opdated invoice number in Excel In other words I want to get a new number each time I open Excel I thank you on beforehand
|