Hi Team,
I am trying to paste values from ("J1:U1") ....numbers like 1 to 12
i wrote code when i am trying to excute that i am geeting error
Sub ColorCells1()
Dim myRange As Range
Set myRange = Range("A1:U1")
For i = 1 To 12
Rows(i, 13) = i
Next i
End Sub
thanks,
Shekar.
I am trying to paste values from ("J1:U1") ....numbers like 1 to 12
i wrote code when i am trying to excute that i am geeting error
Sub ColorCells1()
Dim myRange As Range
Set myRange = Range("A1:U1")
For i = 1 To 12
Rows(i, 13) = i
Next i
End Sub
thanks,
Shekar.