upload your workbook, then you will more likely get a suitable solution.
Yes I understand VBA very well, but without your file I have no way of giving you a precise answer.