View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kelly Kelly is offline
external usenet poster
 
Posts: 132
Default How do I replace the hyperlinks on many cells at once?

I have a spreadsheet of about 4000 rows that I have each row hyperlinked on.
This hyperlink now has an error in it so I was wondering if there is a way to
replace the address in all at once as opposed to replacing them one by one.