KnowledgeHub
Questions
Tags
Users
Search
Alex Rivera
|
Logout
Edit Question
Title
Body
Assume I have a block of data in Excel 2010, 100 rows by 3 columns. Column C contains some duplicates, say it starts off as 1, 1, 1, 2, 3, 4, 5, ..... , 97, 98 Using VBA, I would like to remove the duplicate rows so I am left with 98 rows and 3 columns. 1, 2, 3, ..... , 97, 98 I know there is a button in Excel 2010 to do that but it inteferes with the rest of my code subsequently and gives incorrect results. Furthermore, I would like to do it in arrays, then paste the results on the worksheet, rather than methods such as Application.Worksheetfunction.countif(..... So something like: Dim myarray() as Variant myarray=cells(1,1).Currentregion.value Dim a as Long For a=1 to Ubound(myarray,1) 'something here to Next a
Tags (comma-separated)
Save Edits
Cancel