Thanks Paul,
Problem is i have had to remove some for formatting after adding the new line in. I am a complete novice at VBA (i can paste code into the module) so i am struggling with it.
I have attached the new file in the hope you can help and then by reviewing your previous code, understand the errors in my ways
|