On 27 Nov., 13:23, TFriis wrote:
New problem though, if the sheetname is something like:

Dim shname = "Sheet 2" '(with a space between t and 2)

Then it doesn't work again - solutions anyone?

Ok something like this works:

..LinkedCell = "'" & shname & "'" & "!" & rng(1, 1).Address

But I don't really get it :/