söndag 3 augusti 2008

VBA Lesson 2 - Sort & UniqueFilter

Second lesson has been to learn how to Sort a range and to take that sorted range and Filter out only the Unique values (text and numbers).

I still struggle with ranges. I don't yet have a clear grip on how to handle them.
For instance if I have a range r1 = Range("B1:B10"), how can assign r2 = Range("B1").first cell ?


I just found this: Remove Duplicates

Inga kommentarer: