Hi there thanks for the replies.

I am still getting a type mismatch with the updated code above.
After the type mismatch error it only hides the first row.
Is this not an excel plug in issue?