Changing name in link by using replace all function

  • Thread starter Thread starter darrelly
  • Start date Start date
D

darrelly

Hi all-

If I have a link that points to another sheet on in my workbook and
wish to change that link to another sheet in the same workbook is
there in easy way to highlight the entire row or even just the cell and
use the replace function?

when i try to highlight a row and do that it doesn't seem to work. it
also appears to replace the entire sheet

thanks!
 
Select the range of cells to change.
Then Edit|replace
what: 'sheet 1'
with: 'sheet 99'
replace all
 
Back
Top