copy Ranges to other workbook.

M

Miri

hi, i need to take an area from one excel and to copy it to another workbook.
i want that the ranges that appear in that area will be included also.
i selected the area, and tried to do copy and insert copied cells, but only
part of the ranges were copied...
thanks.
 
D

Dave Peterson

Any chance you had hidden rows or hidden columns that got filled in with the
paste?
 
M

Miri

no.
i mean, i need to copy cells. (includes the data, formating and also the
range names.) maybe i can do it by macro. but how should i get the range
names that included in my selection to copy...?
 
D

Dave Peterson

Maybe you can loop through all the range names on that worksheet and see if any
are completely included in the range to be copied.

Then apply those range names to the pasted area on the other sheet????


no.
i mean, i need to copy cells. (includes the data, formating and also the
range names.) maybe i can do it by macro. but how should i get the range
names that included in my selection to copy...?
Click to expand...
 
Top