Programming

DateDif?
Oh, this is cool. If I paste the formula below into an Excel cell, I get 173. When I try and look up DateDif in excel Help, it doesn't exist. If '9' is the right answer, and SP2 gives 122, what the heck do I have? I'm really glad it's Friday. In the main SP2 fixes and improves things. However here's an o... 5 Mar 2010 12:50

Clarification
Turns out, he did the 'resource' check using Word and my code checks Excel. I'm betting when he tests again in Excel, it will show 6514. I just checked with my 6020/4518 guy and the 4518 is on the 'left' side and the 6020 is on the 'right' side, so xl.Build is pulling in data from the left parenthetical numbe... 5 Mar 2010 12:50

Line break from vLookup
Greetings all, I have a worksheet where cell B8 and B10 perform a vLookup based on a data validation in B6: =IF(B6="","",(VLOOKUP(B6,Position,2,0))) IF(B6="","",VLOOKUP(B6,AD_Groups,2,0)) I have the following code in place to perform a line break after each comma in the returned value. It works great the ... 5 Mar 2010 10:33

Using VBA to gradually change cell interior colors...?
I'm working on a financial project for my employer, and I'm looking for a different way to gradually change the cell color based on a percentage instead of the arbitrary "default style + 3 conditions" type brought about by Conditional Formatting. Please keep in mind that I've not worked with Visual Basic at al... 20 Mar 2010 15:30

Month & Year Text to Date Format - Help Please
Hi, I need some help as i'm stuck... I have a cell which has the number 4 in it (meaning April). I also have another cell which has the number 2010 in it (as text as it is concatenated from having the 20 manually added to the mid of another number giving the 10 part). So basically cell A1 has the number ... 5 Mar 2010 10:33

Strange Range copying
This copies the range once: Sheets("Sheet1").Range("B3:P3").Copy Sheets("Sheet3").Rows(8) This copies the range repeatedly to the end of the row: Sheets("Sheet1").Range("B3:Q3").Copy Sheets("Sheet3").Rows(8) Why? Is there a limit of 15 columns? -- WinXP - Office2003 (Italian) ... 9 Mar 2010 03:29

Check column header value
Hi, I would like to verify the value of certain column header. How does the code looks like? eg. check, if column J = "Product_Name", do A, else stop. if column AC = "Price", do A, else stop. Thank you. choo ... 7 Mar 2010 08:31

Please help me solve my problem
Hi, I Have a cell say a1 that has a continuously changing number it in and I want to track the highest number that it prints, and the same for the lowest number in cell a2. I would like these results to show up in the cells below them Im very new to programming and your help would be much appreciated many th... 5 Mar 2010 05:04

what is the formula for what I want to do
I have a cell that contains a number (lets say 500). In another cell, I want to associate a point scale for the other cell (lets say it is worth one point if it is between 0 and 400, two points if it is between 401 and 600, three points if between 601 and 800, etc.). So the cell that has a value of 500 should... 5 Mar 2010 00:45

vba Function code
I use the 2007 office when I run this I got a error by saying the scale_factor doesnt declared as a compile error. I dont see any problem with the code. Help me on this. Thanks. Function dydx(expression, variable, Optional scale_factor) As Double 'Custom function to return the first derivative of a form... 5 Mar 2010 03:58