Cells concate rpoblem

I'm trying to use the formula as follow:

dim prev as integer
dim cur as integer
dim from as integer
dim str as integer
dim sprev as string
dim scur as string

prev=val(txtFrom.text) 'parse for a value in the text box say =2
cur=prev+1 'is equal to 3
sprev="A" & prev 'gives A2
Scurr="A" & cur 'cur gives A3

'This is what i' intending to do with those values in order to replace equation(1) with equation(2)

Please Login or Register  to view this content.

formula (equation(2)) gives error in excel cells (#Name? in the cells)
My intention is to allow the user to enter the range and the macro could do the rest...
Can any one help...
I'll appreciate.
Thanks

Hi,

You need to deal with your variables outside of quotes as follows:

Please Login or Register  to view this content.