There are a couple of tricks you could try. VBA has some very usful functions, which you should read up on. Try recording a macro of what you are doing, this will give you a starting point. Then you just need to modify it to suit your needs.