Sure it does:

.Range(.Cells(5,rng.column),.Cells(10,rng.column)) .Value = _
createSht.Range("A5:A10")


However, you never said A5:A10 from where. I stated I assumed createsht -
but that may not be what you want. Modify the code to reflect the correct
sheet where the A5:A10 is located.

--
Regards,
Tom Ogilvy

"steveh" wrote in message
...
Tom
Thanks for your work.This brings over the new sheet name, however, it
doenst bring over A5:A10