copy data from a range of worksheet
 

How can I copy data/compute data from multiple worksheet in sequence without
mentioning each of them individually?

thanks,

prashant.
--
Excel is excellent

copy data from a range of worksheet
 

hi,
use the activesheet.next.select command in a loop.

-----Original Message-----
How can I copy data/compute data from multiple worksheet
in sequence without
mentioning each of them individually?

thanks,

prashant.
--
Excel is excellent
.

copy data from a range of worksheet
 

If they are days of the month

for i = 1 to 28
set sh = Worksheets(cStr(i))
msgbox sh.name
next

--
Regards,
Tom Ogilvy

"psp" wrote in message
...
How can I copy data/compute data from multiple worksheet in sequence
without
mentioning each of them individually?

thanks,

prashant.
--
Excel is excellent