Microsoft Office Tutorials and References
In Depth Information
Generating a Unique List
Exl
Figure 16 – Selecting a Range for a Unique List
Figure 17 – Unique List Created
View the Appendix to learn how to store this procedure
in a Standard module.
Option Explicit¶
' * * * * *¶
Sub GenerateUniqueList()¶
'Variable declarations¶
'Range to be used¶
Dim Rng As Range¶
'New worksheet holding the data¶
Dim WS As Worksheet¶
'Change the following variables¶
'Three options exist(all must include headers)¶
Search JabSto ::




Custom Search