Range issue

[punter]

Hello,

The code I have below will identify if anything is in cell P2 and then copy the data under it and place it in the column to the left:

Please Login or Register  to view this content.

The code has been working great but I have been running into a problem. If all the cells under P2 are blank the formula will copy the blank cells and place them in the column O. How can I tell VBA to not attempt to select anything under P2 if the cell directly below (P3) is blank.

Thanks so much in advance.

Eddie

[mikeTRON]

Please Login or Register  to view this content.

[AB33]

Please Login or Register  to view this content.

[punter]

That seems to be working. Thanks so much.

Eddie