add number to string

[cdulong]

I currently have this in a macro that will help me disable buttons. what i am trying to accomplish is as each time the loop goes through it will re populate B28 with:

Button 2
Button 3
and so on


a = 2
Do While a <= 10
But = "Button "
But = But & a
Worksheets("Index").Range("b28").Value = But
a = a + 1
Loop


The problem i am haveing is when the code is ran i get an error stating Type Mismatch any help...

THanks,
cdulong

 

[white605]

changing
But = But & a
to
But = But & str$(a)
might work for you

This old world keeps spinning round - It's a wonder tall trees ain't layin' down

 

[cdulong]

thanks but that didn't work I was still giving the same error

 

[PHV]

Which line of code is highlighted when the error raises ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[SkipVought]

What kind of control?

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[cdulong]

there isn't all it gives me is

Runtime error '13':

Type Mismatch

 

[SkipVought]

Hit your DEBUG button and see the line of code highlighted.

I'm guessing it the But code.

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[fumei]

From an Excel idiot....

I do not get a Type Mis-match if I have:

Dim But As String
Dim a As Long

Nor do I get a Type Mis-match if I have:

Dim But As String
Dim a As String

which makes me wonder what you have But and a declared as.

Gerry

 

[cdulong]

Thanks for your help but I ended up scrapping the idea that I going to use.

Thanks,

 

[fumei]

That certainly is one solution.

Gerry