Variable into a Formula

[aitor]

I've been working for ages and I'm stuck with this problem.

I'm programming with visual basic excel and I simply want to write a formula where the variables change.

The formulae I want to program is =E16&D11&H19 where the numbers 16 and 19 are variables.

ActiveCell.Formula = "= " & "A" & y &" & "& "D11"&" & "&"D" & p & " "

I've been trying with the code above but it doesnt work out.

Anyhelp?

 

[VoG]

Is it

ActiveCell.Formula = "=E" & y & "&D11" & "&H" & p

 

[Misca]

Maybe something like:

Dim a As Long
Dim b As Long

'=E16&D11&H19

a = 16
b = 19

ActiveCell.Formula = "=E" & a & "&D11&H" & b

 

[aitor]

Maybe something like:

Dim a As Long
Dim b As Long
 
'=E16&D11&H19
 
a = 16
b = 19
 
ActiveCell.Formula = "=E" & a & "&D11&H" & b

It worked out!!! thank u so much!! still dont understand why I dont need a " at the end of the expression though.

Cheers mate!