Hi!
Thank you for your answer. But I get the following error :
Erreur 9 : l'indice n'appartient pas à la sélection. I can't figure
out how to translate it but here is the MS page :
http://support.microsoft.com/kb/468889/fr
Any idea what to do...?
Souriane
On 1 mai, 13:34, Roger Govier wro
Hi
Try the following code.
It assumes that column A has the maximum number of entries, to determine how
many rows to loop through.
If that is not the case, change the column letter from "A" to wahtever you
wsih.
Sub CopyLines()
Dim wsS As Worksheet, wsD As Worksheet
Dim lr As Long, i As
