I need to create hyperlinks on a particluar worksheet in a workbook. I then need to copy each hyperlink and the displayed cell value to other cells on the same worksheet. No matter what I try, I can't getthe link to copy exactly as it is. Each link is to a different worksheet on the workbook, so the oriinal links were set up using the "Place in ths Document" feature for hyperlinks. They appear as Sheet2!A1 for example. And nothing I do copies this hyperlink unchanges to the other 4o locations I need it in the sheet...