Copied below, I have a series of monthly cash flows for a project. The IRR function is giving me a "#DIV/0!" error, while the XIRR gives me a return of...

Hi How do we add into VBA a code to insert a name into a cell when another cell has a specific word selected from a validation list. Any help would be...

I have a database of 15000 customers postcodes - I need to know the number of customers per code - how do i count the number of repeated codes

Hi All, i want to untick the standard,formating,Borders etc. options in toolbars list option. see the attachment. Thanks&Regards, Amar...

Does anyone know how to project the due date according to a required number of working hours? such as If today is 24 Oct, 2005 (Monday) at 9:00am, my project...

Hi everybody !! i come again here with a problem i can seem to solve :s i hope someone will be able to give me a hand on this... here it is : i have a sheet...

Hi, We use excel for our reports and for security reasons, we do not want to give 'Open' option to our users. We are able to disable the 'Open' menu option...

Good morning! I have a workbook with several macros. Ones that I recorded during the same session (without closing) are listed on 1 page with a line...

I have datas typically numbers in 3 coloumns, i need to look up the number from coloumn 3 with coloumn 2 and the corresponding coloumn1 number should...

what is the coding to close a form: user form named frmCenter. on click event of button i want to terminate frmCenter. Thanks in...

HI all, I am making one template where i want engine name to be selected from the drop down menu and all the parameters are automatically filled in separate...

Hi all, I would like to know that can i make mail merger type of application in Excel??? eg. I want to make one form for parameters of engine. Where i should...

Hi everyone, Can anyone help me in creating mail merger type of application in Excel... its important. I want to select one record (may be by drop down form)...

I have the months in column A and the data in column B. I am doing a bar chart - everything working fine. Now I need to add the goal as a line going across...

GRINDLINES will not show in PRINT PREVIEW nor will they change color to BLACK as I want them to using TOOLS OPTIONS VIEW All Background Settings are in...

Hi, I have serveral very large spread sheets, and I need to insert a blank row when the data changes in a column for...

I have a workbook with a series of hyperlinks from one sheet to certainl cells in another sheet. When i protect the destination sheet the hyperlinks no longer...

Hi, I have a workbook that is years old. At the time I created it, I included code so numbers (time) could be entered without the use of a colon. The code was...

Good morning. I have this problem: when I double click on Excel file to open it, the program opens but the Excel file not (I don't see it because it doesn't...

I have created 3 user forms in excel so as to capture survey data. What code to I require to link them using multipage. My form names...