Optitron,

I didn't put ..Cells - I put .Cells. (That is probably a result of your web interface.) Taking out
the single dot and using Cells means that the summary table will be placed on the active sheet,
rather than the sheet indicated by the With statement. If that is okay, then you don't need the With
statements. Also, you could also use a worksheet activate command to choose which sheet should be
active.

HTH,
Bernie
MS Excel MVP


"Optitron" wrote in message
...

It worked. The lines that you put ..cells were red so I changed it to
cells and it worked perfect.


--
Optitron
------------------------------------------------------------------------
Optitron's Profile: http://www.excelforum.com/member.php...o&userid=26729
View this thread: http://www.excelforum.com/showthread...hreadid=467639