Hi,

I don't understand why pasting a link is a method of the worksheet object
instead of the rangeobject.

According to the helpfiles, the paste methode takes either of 2 parameters:
destination or link

If you use destination, pasting as link is impossible.
If you use link=true, you cannot enter a destination and the link is pasted
to a cell which you have selected previously.

Avoiding selects is a fetish of mine. What other situations require
selecting ?


thx

Ward