sSelection = Selection iStart = Selection.Range.Start ' save the highlighted address iEnd = Selection.Range.End