Hi and welcome to the board.
I suggest you post your macro so that the VBA guys can have a look at it