Almost the same...

It actually activates that worksheet. wks.range(...) doesn't depend on the
selection of sheets.

And if the code is behind a worksheet, it still won't work correctly.

It's not usually a good idea to select sheets, select ranges or activate
workbooks. It just slows things down and makes it more difficult to debug the
code (my opinion).

sa02000 wrote:

Dave, Thanks. I will try your solution. Also, I found out that adding
the following line after worksheet FOR statement does the trick too.

wks.activate

which really does the same thing that you are saying.

Thanks Again.
Jay

--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=568789

--

Dave Peterson