chungtinhlak
01-19-2009, 05:08 PM
Can i do this? it gives me an error at "M" & i. I tried it without " ", and () and everything, just can't figure it out.
Sub calcution()
Dim m1 As Long, m2 As Long, m3 As Long, m4 As Long, m5 As Long, _
m6 As Long, m7 As Long, m8 As Long, m9 As Long, m10 As Long, m11 As Long, m12 As Long, m13 As Long, m14 As Long
For i = 1 To 14
"M" & i = range("y" & i).Value
End Sub
Thanks
Sub calcution()
Dim m1 As Long, m2 As Long, m3 As Long, m4 As Long, m5 As Long, _
m6 As Long, m7 As Long, m8 As Long, m9 As Long, m10 As Long, m11 As Long, m12 As Long, m13 As Long, m14 As Long
For i = 1 To 14
"M" & i = range("y" & i).Value
End Sub
Thanks