Try selecting the column and:

Sub collum()
For Each r In Selection
v = r.Value
r.Clear
r.Value = v
Next
End Sub


--
Gary''s Student - gsnu200770


"Cody Kid" wrote:

New subject for me: Whenever we input or import address lists from
customers, the hyperlink is usually active. We can click on the cell around
an active hyperlink, then use the arrow key to access that cell, right click
and inactivate the hyperlink. However, we can only do it one at a time. How
do we highlight a column of email addresses and then make the entire column
inactive? I sure hope that is possible. It will save us a lot of time.

Thank you,