Hello guys - its me again.
I have managed to make additional changes to the macro below and it runs well. Only issue here is that it only looks at worksheets named book1. The macro will be used on worksheets that are named differently so i tried to change it look the active sheet. I tried using examples found online but kept running into issues.
Here is what I entered :
to replacePlease Login or Register to view this content.
Please Login or Register to view this content.
Please Login or Register to view this content.
Bookmarks