proper syntax for With Rng/Evaluate?

[ilcaa]

i have a range(1000 rows) that i want to apply a change to. Its basically taking a variable and placing at the front of each string along with a comma. here is a before and after

6 of 1998 3-0-1 100.00% 14-18-2 43.75%
36, 6 of 1998 3-0-1 100.00% 14-18-2 43.75%

variable was 36 in this case. I though it was simple enough, but i get a 'Type MisMatch' error.

What is proper syntax, would EVALUATE help out?? thanks

Formula = 36

With Rng
    .Value = Formula & "," & .Value
End With

 

[Fluff]

Like

Sub ilcaa()
   Dim Strategy As String
   Strategy = "36"
   With Range("A1", Range("A" & Rows.Count).End(xlUp))
      .Value = Evaluate("If({1},""" & Strategy & ", ""&" & .Address & ")")
   End With
End Sub

 

[ilcaa]

is there anyway you can explain why so many quotes are needed, why they are placed where they are? i cant figure out the logic of these evaluate statements especially with so many quotes and & symbols...

 

[footoo]

Doesn't post #5 do what you want?

 

[James006]

May be you could clearly explain your expected ' final result ' ...