Peo,

Thank you for your reply. As usual my first post did not give an
important detail of what I am trying to do. What I think you described
is the manual operation to copy the cells (and their formats) to a new
spreadsheet. I would like to do this same operation but automatically
with a function in the destination spreadsheet that extracts the info
from the source spreadsheet. Automatically carrying the formats
forward would be a plus but not mandatory. I am able to automatically
copy cell by cell using a formaula like:

='C:\path\[source.xls]Sheet 1'!$A$1

and with cut and paste put this into each cell of the destination
workbook but I was curious to know if I could simplify that process
with a range name to get all the cells of interest????

John Keith
kd0gd@juno.com