Thanks Boss I really appreciate it.

Chris
-----Original Message-----
Try this example Cris

http://www.rondebruin.nl/copy2.htm

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2002 SP-2)
www.rondebruin.nl



"Chris White" wrote in message
...
I am new at VBA Code. I am trying to take multiple
spreadsheets and combine them into one summary sheet. I
am
not quite sure how to do this since I can have any
number
of spreadsheets that I am trying to combine into this
summary the good thing is the sheets always have the
same
range. I believe I need to do a loop but I am not sure
how to identify the next empty cell in my summary sheet.
Please Help..

Chris


.