I've defined a range:
HiddenArrayBegin = ActiveCell.Offset(1, 1).Range("A1").Address
I want J2 in the formula below to be this variable:
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=AND(B2="""",J2<>"""")"
How can I write that?
HiddenArrayBegin = ActiveCell.Offset(1, 1).Range("A1").Address
I want J2 in the formula below to be this variable:
Selection.FormatConditions.Add Type:=xlExpression, Formula1:= _
"=AND(B2="""",J2<>"""")"
How can I write that?