Hi
not quite sure but have a look at
http://www.rondebruin.nl/copy2.htm

--
Regards
Frank Kabel
Frankfurt, Germany

"Radomir" schrieb im Newsbeitrag
...
Please
I can not move ranges located on separate sheets and
gather them into one big range. On 7 sheets I have
ranges: "monday", "tuesday" etc. Each range has the same #
of columns only number of rows is a variable. How to
collect all the data into one big range "week" located on
separate sheet of course. It seemed to be easy for me.
Thans Radomir