Using variables in a Range

[mansh]

Hi

I am trying to write a formula in a range. I am suing the code below to define my range:

range("b" & m + n + 11&":k" &m+n+11)

m, n are defined as integers

VBA doesn't seem to like it. It highlights ":k" and comes back with the message: "Compile error: Expected: list separator or )"


Can someone tell me what is wrong ? I am able to use notation such as Range("b13:B" & m + 9) without any problems.

Thanks for your help

 

[Misca]

Try adding a space between the 11 and the "&" and that should fix the problem.