cella

Hi everybody, i'm having issues with the following macro that i want to include in a spreadsheet to prevent the user to give the file to unauthorized third parties. basically, i want to make the file readable only by a specific "computer name". hereby the macro: Private Sub...

Hi There Forum, I have pilfered a great code that finds duplicates on two sheets and highlights the duplicates on the newest sheet. I'd like to add a function that will copy the data from rng1 "K" and paste into rng2 "K" as well as highlighting. I've tried manipulating the code myself, but...

Dear All, The code below searches for duplicate in different sheets of my workbook. The issue is that it takes a little while for it to be done. How can i add a progress indicator in the status bar at the bottom. Thank you & Kind regards. Sub dup() Dim cell As Range Dim cella As Range Dim...