excel - Delete duplicates between two sheets "Case Sensitive" -


i want compare 2 sheets in excel , if vba found duplicates delete them. have searched while , have find want here. "how delete duplicates between 2 excel sheets vba"

but in case didn't work me. because script consider abc , abc duplicates. there anyway modify script case sensitive letters.

change comparemode of dictionary. detailed information have here: http://msdn.microsoft.com/en-us/library/a14xez73(v=vs.84).aspx

dim dict object set dict = createobject("scripting.dictionary") ' add line: dict.comparemode = binarycompare 

Comments

Popular posts from this blog

Capture and play voice with Asterisk ARI -

c++ - Can not find the "fiostream.h" file -

java - Why database contraints in HSQLDB are only checked during a commit when using transactions in Hibernate? -