Firstly it would be helpful if you could post the code you are using,
secondly you don't say how you define the range in each sheet, when you
say selected sheets are you grouping them? if not by what means are you
or the user selecting them?

filo666;212818 Wrote:
Hi, I have a macro that takes all the ranges of the selected cells (in
each
worksheet) and paste them wherever the user wants, the thing is when I
select
two or more sheets the ranges of all the sheets are lost and in all the
sheets appears the range of the first sheet, how can I mantain the
ranges in
all the selected sheets?
TIA


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=58415