Str() Why does it add a space?

[nochoice]

Hello,

I have a simple For loop in a Word Macro

For i = 1 To count.Value

rnga = "A" + Str(i)
rngb = "B" + Str(i)
oWbk.Sheets(1).Range(rnga).formulaR1C1 = myarray(0, i)
oWbk.Sheets(1).Range(rngb).formulaR1C1 = myarray(1, i)

Next i

My only problem is Str(i) returns the value of i as a string but it includes a space before the number so it looks like A_1 - where _ is a space.

Any suggestions?

Thanks in advance,
NoChoice

 

[Zathras]

Str() is allowing for a possible negative sign (whether it needs to or not.

Most of us eventually figure out (or observe in other posts) that you can do this instead:

  rnga = "A" & i
  rngb = "B" & i

and it gives you what you want.

 

[nochoice]

Thanks for the quick response.

It works well.