I am still confused. The range names that I have are pg1 all the way to pg10
right now. I may have more later. These range names are on each sheet of
one workbook. I want to go to the range name that I created and copy the
range to another worksheet which I have call data that is located in the same
workbook. When I copy to the data sheet I want to past special value and
transpose. After that is done I want to go get pg2 and put it into data at
active file. Please help.
--
Mr Speedy