reset cell.Hyperlinks.Count to 0
 

How do I reset cell.Hyperlinks.Count to 0? I tried

If cell.Hyperlinks.Count < 0 Then

cell.Hyperlinks.Count = 0

This doesn't work.

Any suggestion?

Thanks.

reset cell.Hyperlinks.Count to 0
 

You need to delete it:

cell.Hyperlinks.Delete

Ken Puls, CMA - Microsoft MVP (Excel)
www.excelguru.ca

John Smith wrote:
How do I reset cell.Hyperlinks.Count to 0? I tried

If cell.Hyperlinks.Count < 0 Then

cell.Hyperlinks.Count = 0

This doesn't work.

Any suggestion?

Thanks.