View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Howard Howard is offline
external usenet poster
 
Posts: 536
Default Code copies between key word is in reverse order

Hi Claus,
Hmmm, I thought I saw results as you described them to be a couple of times in testing but now here is what I get.

I inserted your code snippet and added a deletion of column A.
Here is what I get, where the right hand column below was what I had in column A, A1 to A25 and the left hand column is the results starting in A3 to A14 after running the code.

XX
nn1
nn7 nn2
nn8 XXX
nn9 nn4
nn10 nn5
XX
nn15 nn7
nn16 nn8
nn17 nn9
nn18 nn10
XXX
nn1 nn12
nn2 nn13
XX
nn15
nn16
nn17
nn18
XXX
nn20
nn21
nn22
nn23
nn24


Regards,
Howard