Visual basic ref in formula

[fletch]

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?

 

[dk]

Something like:

Sub Test()
Dim HiddenArrayBegin As String


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="""", " & HiddenArrayBegin & "<>"""")"

End Sub

HTH
Dan