Get instant live expert help on I need help with excel boolean cell

Excel VBA not incrementing the value of a specific cell. Function SayIt(cell1 As Variant, Optional baSync As Boolean, Optional bPurge As Boolean) ThisWorkbook.Worksheets("Latest").Activate Dim Roll As Integer, result2 As String Roll = ThisWorkbook.Worksheets("Latest").Range("d2").Value ' The value of cell D1 is currently 1 MsgBox "Sayit Before ROLL " & Roll Roll = Roll + 1 MsgBox "Sayit After ROLL " & Roll End Function

I have a big issue with a conditional format in which a date must reference a date that in is text format. My issue is with the boolean logic when referencing part of my data. I need a very experienced expert because some of this stuff is complex.

Hi All, I have found a nice little code that allows me to insert a row when double clicking on a cell, copying contents as well. I was wondering if I could change it so it inserts a row if you click on the cell value '+' and deletes a row if you click on the value '-'? allowing me to insert and delete rows when needed. Private Sub Worksheet_beforedoubleclick(ByVal Target As Range, Cancel As Boolean) Cancel = True Target.Offset(1).EntireRow.Insert Target.EntireRow.Copy Target.Offset(1).EntireRow On Error Resume Next Target.Offset(1).EntireRow.SpecialCells (xlConstants)

I have a large transaction dataset that I need to reformat to be able to analyze. My two columns must into several columns w boolean values based on transaction number. From this: to this: transaction# Item transaction# Milk Eggs Cheese 001 Milk 001 True True False 001 Eggs 002 False False True 002 Cheese I hope this makes sense...Thanks!

So the array that I'm working with is L31:V51. I'm trying to refine the information down below from K59:Q89. What I'm having trouble with is the way in which I craft my index match. To my understanding, I can trick the boolean and use multiple criteria to grab information (with an array formula), but I'm still unable to get the correct information. Is my formula written correctly? {=INDEX(M33:V51,MATCH(1,(L60=L33:L51)*(M59=M32:V32),0))}