ACN

Sheet1.QueryTables(1).Delete

will delete the link, but not the data

http://www.dicks-clicks.com/excel/Ex....htm#DeleteVBA


--
Dick Kusleika
MVP - Excel
Excel Blog - Daily Dose of Excel
www.dicks-blog.com

"Air_Cooled_Nut" wrote in
message ...

Thanks Tom. I was thinking of the copy/paste method as well but I was
hoping for a cleaner way (a method or property). I'll use what you
suggested :-)


--
Air_Cooled_Nut


------------------------------------------------------------------------
Air_Cooled_Nut's Profile:
http://www.excelforum.com/member.php...o&userid=15730
View this thread: http://www.excelforum.com/showthread...hreadid=273339