Hi Gene,
How about Copy, Edit, Paste Special, Paste Link. Or Insert, Hyperlink.
Both of these techniques work. You may need to use range names to make
using the Hyperlink approach easier.
Cheers,
Shane Devenshire
Microsoft Excel MVP
"Gene Hawkins" <rustic39@[EMAIL PROTECTED]
> wrote in message
news:C3EEF985.A107%rustic39@[EMAIL PROTECTED]
> Is there a way to create a (paste as) hyperlink to connect a cell value
in
> one worksheet to a cell value in another worksheet within the same
> workbook?
>
> Thanks -
>
> Gene
>
>
> Posted Via Usenet.com Premium Usenet Newsgroup Services
> ----------------------------------------------------------
> ** SPEED ** RETENTION ** COMPLETION ** ANONYMITY **
> ----------------------------------------------------------
> http://www.usenet.com
