| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count Consecutive A's with a reset | Excel Worksheet Functions | |||
| Count and Reset Button Clicks | Excel Discussion (Misc queries) | |||
| count cells, then reset count when value in another cell changes | Excel Worksheet Functions | |||
| Reset sheet count | Excel Discussion (Misc queries) | |||
| Excel Hyperlinks- cell content v. hyperlinks | Excel Discussion (Misc queries) | |||
Hybrid Mode
