Functions

Excel 2007 - Personal Macros
My personal macros workbook no longer opens when I start Excel. I have found it in the XLSTART, and I can't see anything wrong with it, but it doesn't open unless I manually open it. -- Can someone help? Thnx.. SB ... 5 Apr 2010 15:01

Complex If
Any ideas where I went wrong here. Can't leave the cell =IF(AND(U2="YES",OR(E2="Not-applicable",E2="Red"),"Yes","")) ... 5 Apr 2010 13:53

Weeknum formula
Hi, When I use the weeknum formula to calculate the week number on today's date (5th April 2010), the result is 15 (week no.15) irrespective of the return type 1 or 2. However, according to the Calendar in my Lotus Notes, the week starting 5th April 2010 is Week no.14. I think the difference in Week No. be... 5 Apr 2010 13:53

Coloring
Dear Expert, My office is still using Excel 2000. Conditional format can go up to 3 only. Is it possible to use if function to add more? Say certain certeria are fulfilled then show up a color or change fonts ...? Is it possbile? Thanks ... 5 Apr 2010 10:30

Data moving 3
Hi I need to a code, when run it on any sheet, copy of column X paste to a file (R.xls) in sheet1 and locate on column H respectively. in otherwords, first run of desired code, paste column X to column H of R.xls and second run,paste column X to column I of R.xls and so on. best regards ... 8 Apr 2010 02:55

Cell selection - turn it off
I am having an issue where when I open an worksheet, it is automatically selecting cells and I can't figure out how to turn this off. As soon as I open the worksheet, excel is automatically selecting cells when my mouse hovers over them and I can't do any other function. How do I stop this? ... 5 Apr 2010 09:24

WHEN ENTER NUMBER , DISPLAY IN WARDS ?
how can we get in words , when enter number that time display in words ... 5 Apr 2010 08:18

Address of cell in VBA
I want to make a UDF, in which I use the address of the cell itself in VLOOKUP. How do I define the address of the cell ? cell("address") give an error Tx, Gilbert ... 5 Apr 2010 09:24

How to combine Combo Box function with Vlookup function
I have many items to input into my selection list in my worksheet. Hence, I came up with the Combo Box (from FORM under Toolbars) function. In addition, based on the "answer" selected from the combo box, I need to generate the other details based on this "answer". Is it possible to incorporate my Combo Box s... 5 Apr 2010 09:24

Calculations
Dear Sir, I want to calculate formula which refers 3 cells out of 4 cells. for eample a1=5, a2=2, a3=9, a4=16. i can able enter all the 4 cells, if i enter the values in cells a1,a2 & a3 the result should come in a4, if i enter the values in cells a2, a3 & a4 the result should come in a1, like all the 4 cells.... 4 Apr 2010 17:05