Macro: Move Duplicate Rows From One Worksheet To Another

Originally Posted by fredlo2010

...
Just some ideas.

Thanks for the tips. The Wikibooks article appears to be very comprehensive and useful.

I always declare Option Explicit to make sure I don't forget to declare all variables & constants.

I obviously know the difference between a sub and a function.

I disagree that VarName as Long is any better than VarName&, and the latter is more concise.

I prefer to use short variable names, especially when they have limited scope,
e.g., i as the counter variable in a For ... Next loop.