Extending column range in copy paste macro

Can someone help me change this code that is copying the data from column I:BY. Instead I would like to copy data from column B:BY

This is the part of the code that I need modified..

Please Login or Register  to view this content.

This is the entire code..

Please Login or Register  to view this content.

The code seems to be somewhat inefficient. I can't open the file because I don't have Excel 2007, but I will suggest that you do not need to select cells to modify them. I've made some changes to your code, but I wasn't able to test it, so report back with your findings

Please Login or Register  to view this content.

Here is a copy of the workbook in 2003 format.


I made the change but there must be another problem with the code. The code is copying the first row that meets the criteria continuously. After copying the first row, it does not jump to the next row that meets the criteria.

Any idea what can be wrong?