also do you know

if I input the column field from the user




the user inputs something like g1 and g6

I am inputting in userform

input1=userform.textbox1.value
input2=userform.textbox2.value

display1=userform.textbox3.value
display2=userform.textbox4.value

in input1:input2 the data is there to read

and in diplay1:display 2 the data has to be display


that is the formula will now become


Sub count()
Range("display1:display2") = "=LEN(MID(input1,2,LEN(input1)-2))-LEN(SUBSTITUTE(MID(input1,2,LEN(input1)-2),"","",""""))+1"
End Sub


so in this it is giving me global error..

i think excel is not accepting these variables

please help

you have been very helpful which I greatly appreciate!