I understand that it is best practice to never use Range.Select in
Excel VBA as it will often throw up bugs. I have found several examples
for this from trawling the groups and it has happened to me several
times when developing.

However, i am at a loss trying to understand where the problem lies.
Can anyone tell me what causes the bug?

If you need a specific example i can try and create one.

Many thanks

Dan