for each sh in worksheets
sh.range("b2").copy where????
next sh

--
Don Guillett
SalesAid Software

"Roog" wrote in message
...
I have 125 sheets with every sheet displayed in the same manner. Now I
would
like to copy cell B2 (and some more cells) of every 125 sheets into one
new
sheet (table). As it would take too much time to copy everything manually,
i
would like to know if there is a quicker way?

hope anyone can help me,

Roog