Data from Inputbox changes formula...

[cmhoz]

I have a macro that inserts a new sheet and names it what the user tells it to in an inputbox called AccountNo.

I then want the macro to go to a cell on the index sheet and put a formula in cell E11 that sets that cell equal to a cell on the newly created sheet.

something to the effect of

Sheets("Index").Select
Range("E11")="=&AccountNo&!R[11]C[2]

So.. if the user calls an account "AFS" then it will grab the data from AFS!R[11]C[2].

BUT... obviously my syntax is wrong somewhere 'cause it doesn't work!

Any idea how to get that inputed AccountNo to stick itself into the formula???

Thanks

 

[cmhoz]

ha. fixed it myself.... got lost in all my "&"&"

All better now.