Mantaining ranges if several sheets are selected

[filo666]

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

 

[filo666]

the code is huge, impossible to paste it, simple:
the user selects range a1:a5 and range b3:c5 from sheet1, he selects range
g4:g6 and range v6:n9 from sheet2, he selects both sheets and the ranges of
sheet1 are lost.

 

[filo666]

I already have that part in my code, let me try to explain my self better:

Could you do this please:

1)select range("A1:A6") in sheet1
2)select range("v1:v6") in sheet2
3)select sheet1 and sheet2 (with key shift presed and cliking with your mouse)
4) now enter to sheet1 or to sheet2, you will find out that one of your
ranges was lost!!!!