General Topics in VBA

Remove Duplicates (Excel VBA Code)

Submitted by Support on Tue, 06/24/2008 - 05:12

Public Sub DeleteDuplicateRows()
'
' This macro deletes duplicate rows in the selection. Duplicates are
' counted in the COLUMN of the active cell.

Dim Col As Integer
Dim r As Long

Code to List All Named Ranges in a Worksheet

Submitted by Support on Mon, 04/20/2009 - 19:52

The following code will list down all the named ranges in an Excel Worksheet.