Leaderboard

What are your current units?

Perhaps you could post the linetype definition you have managed so far. It is easier to help if we know what you have already. One or two comments might help you. Have you looked at existing linetypes? ZIGZAG comes to mind. Have you decided on what font you want the letters to be? Spacing of the elements of the linetype are important and different fonts have different sizes. If you set the font in the definition to STANDARD, then anyone else might have a different font for that. Make a new Text style with your chosen font.

Have you looked at using dcl list multiple times can scroll up down and pick just 1 line. There is plenty of library make a list dcl out there. I use one from Alan J Thompson. Lee-mac has a nice one as well can select multiple lines. It may be possible to remember output list and add more from new lists. Lee may comment about that.

Sub test() For Each cell In ThisWorkbook.Sheets(1).Range("B2:B15") Set Arg1 = Sheets(1).Range("B2:B15") Arg2 = Sheets(1).Range("B" & cell.Row).Value Set Arg3 = Sheets(1).Range("C2:C15") Arg4 = Sheets(1).Range("C" & cell.Row).Value Sheets(1).Range("E" & cell.Row).Value = Application.WorksheetFunction.CountIfs(Arg1, Arg2, Arg3, Arg4) > 1 Next End Sub @Kalsefar If the value of Cells in column "E" will be true means that cell with lat & long on specific row it's duplicated, if false not. Of course you can use a wide range, more filtering criteria adding Arg to function, and a variable instead writing a value TRUE or FALSE in the specific cell.If you want you can delete the Row, everything checking if result from function it's true or false. Test.xlsx