And maybe you'll get a better response at your other post.

Dave Peterson wrote:

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????

Miri wrote:

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...?
--
Miri Tz.

"Dave Peterson" wrote:

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

Miri wrote:

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.
--
Miri Tz.

--

Dave Peterson


--

Dave Peterson

--

Dave Peterson