Prev: Get External Data from Web
Next: update user name in excel on open
From: joel on 14 Apr 2010 11:43

The line of code was from your original posted code. The name of the
sheet should match the TAB name of the sheet in the workbook. since I
don't have your workbook I had to assume the sheet name was correct.

"Destsheet" (no double quotes) should be a tab in the same workbook
where the macro is located. Make sure the are no extra spaces in the
TAB name.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=195120

http://www.thecodecage.com/forumz

First  |  Prev  | 
Pages: 1 2
Prev: Get External Data from Web
Next: update user name in excel on open