Ok thanks again
I entered the duplicate names manually and rerun the script, and it updated it in sheet 1.
Also it said i had a error 438 in the script, it was highlighted it was in the
(v.Range("A1:O1000").ClearFomats), i just guessed that it was the fomats needed to be formats, and i changed it then i could re run the script.
I Got Lucky i guess, lol
Thanks Rog
|