scadaman29325
New Member
- Joined
- Oct 13, 2002
- Messages
- 23
I've got a big spreadsheet (17k lines) that has a lot of duplicated lines in it, I've sorted and want to delete the dupped lines.
How can I do this? Below is an example of my idea, but I know it needs help.
TIA
Phil
Sub PastdueDeleteDupRows()
'
' PastdueDeleteDupRows Macro
' Macro recorded 10/29/2002 by Phil Hasty
' Sub
' If Row(#) = Row(#+1), Then Delete Row(#), IfNot (#+1)
' If Row(#) = (blank), End, Goto Sub
' End
'
How can I do this? Below is an example of my idea, but I know it needs help.
TIA
Phil
Sub PastdueDeleteDupRows()
'
' PastdueDeleteDupRows Macro
' Macro recorded 10/29/2002 by Phil Hasty
' Sub
' If Row(#) = Row(#+1), Then Delete Row(#), IfNot (#+1)
' If Row(#) = (blank), End, Goto Sub
' End
'