untested:

TableDestination:=Worksheets("SheetRef").Range("K4 ")



Hru48 wrote:

Thanks, but I get the error ' Subscript out of range'. any ideas?

--
Hru48
------------------------------------------------------------------------
Hru48's Profile: http://www.excelforum.com/member.php...o&userid=24895
View this thread: http://www.excelforum.com/showthread...hreadid=558821

--

Dave Peterson