range with L C
 

I want copy range("a3:d3")

but I want repat to line 4, 5...

how execute a looping For with coordenate?

thanks

range with L C
 

Hi Marina

See this small example for row 3 - 10
it will copy to E

Sub tetsting()
Dim rw As Long
For rw = 3 To 10
Range("a" & rw & ":d" & rw).Copy Range("E" & rw)
Next rw
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


"Marina Limeira" wrote in message ...
I want copy range("a3:d3")

but I want repat to line 4, 5...

how execute a looping For with coordenate?

thanks