Welcome to the VBAX forum, luckysmit. You will notice that I've changed a couple of things in your post.

Firstly, when presenting code to the forum, we would prefer that you wrap your code in Code Tags. See the Hash icon third from the right in the grey section immediately above your post? If you select your code then select that icon it wraps your code with the preferred code tags.

Secondly, sections of code the Start "Private Sub".... "End Sub" with no code in-between are basically irrelevant and really shouldn't be included. For that reason I have deleted them.

And finally, For long lines of code, try breaking then a reasonable length by selecting a point, add a space then the Underscore hypen and press enter to start a new line. Most people have small screens and this makes your code more readable to them.

Hope this helps you for future posts.