# d15

1. ### IF

I've discovered this thread from a little time, so if it's possible i post another doubt. I have this formula (really is longer but if a part is correct i suppose that all can be correct as well) =IF(D15<>0,5 +IF(E15<>0,5 +IF(F15>0,5))) I wanna have a total that give me a value if any,one,or...
2. ### Copy only texts and values only but not formulas from one workbook to another

Is there a macro that copies only text and values but leaves the formulas in their cells when copying ranges from one workbook to another? Some ranges have formula in them but I do not want to copy them from one workbook to another. ODIN was kind enough to send me the code that copies...
3. ### Single Cells with Range on Workbook BeforeSave

Hi everyone, I have a problem with a Macro that checks if certain cells contain data before the workbook can be saved. I copied the VBA code from the Microsoft online documentation about the Workbook.BeforeSave Event (Excel) and I cannot get it to work if working at Workbook level. The VBA...
4. ### Very tricky problem, can anyone help?

Hello! =IF(AND(D15>=\$J26,D15<\$J26+7),\$G26,IF(D15>\$J26,INDEX(\$H\$38:\$H\$136,COLUMNS(\$D\$16:D16)),0)) If the date D15 is within the range AND(D15>=\$J26,D15<\$J26+7), then fill the cell with \$G26. If the date D15 is outside the above range, and it is lower than \$J26, then fill the cell with 0. If the...
5. ### Excel complex formula for me..

Hi All, Couple of things i havent been able to get sorted out yet, first if C15 is 50 or less add 1 to D15 and 2 to E15, or if C15 is =51 <75 add 1 to D15 and 3 to E15, etc.. 2nd if O2 or R2 is Purple,Orange,teal or aqua and H2 is red add(Sheet2-C15 to sheet1-F17),green add(Sheet2-D15 to...
6. ### VBA Multiple condition formatting for OR statements.

So I'm looking to do something in VBA that has multiple conditions.. Dim Cutwidth1butt2 As Integer Cutwidth1butt2 = [M7].Value - [E14].Value If [C14] = "2" Or [C15] = "3" Or [C16] = "4" Or [C17] = "5" And [D14] <> "" Or [D15] <> "" Or [D16] <> "" Or [D17] <> "" And [E14] <> "" Or [E15] <> ""...

### This Week's Hot Topics

• VBA (Userform)
Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
• List box that changes fill color
Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
• Remove duplicates and retain one. Cross-linked cases
Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
• VBA Copy and Paste With Duplicates
Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
• Macro
is it possible for a macro to run if the active cell value is different to the value above it
• IF DATE and TIME
I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...