where do my & & & signs go?

Hi All,

I think I'm being a bit thick today and require some help. I have the following code in a macro:

Range("E18").Formula = "=SUMPRODUCT(--(RESULTS_CD!$AL$3:$AL$51&"" ""&RESULTS_CD!$AK$3:$AK$51=$E$4&"" ""&$B5))"

Instead of the part with:

RESULTS_CD!$AL$3:$AL$51

I want to use something along the lines of:

RESULTS_CD!$AL$3:$AL$ & LastRow &

LastRow has already been figured out earlier in the code.

Can anyone show me the full line of code with the & LastRow added?

Thanks
dvent

Range("E18").Formula = "=SUMPRODUCT(--(RESULTS_CD!$AL$3:$AL$" & LastRow & "&"" ""&RESULTS_CD!$AK$3:$AK$" & LastRow & "=$E$4&"" ""&$B5))"

Richard