Exceluser said:
Hi A,
Thank you so much for your help, the While statement and empty is
giving me an error.
Hi
Whats happening here is an issue here with my code rolling into multiple
lines when I pasted it into the posting.
I have attached a txt document where I copied and pasted the code straight
from the VBA module. This should preserve where new lines are appearing.
Try copying from this and see if it works. If not I can send you the .xls
itself if you supply an email address.
Regards
A
