What range do you want to copy, and do you want it to the same place on
other sheets(e.g. G10:L55 -G10:L55), or somewhere else (e.g.
G10:L55-A1:F46)?

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"rvik " wrote in message
...
bob,

i got it running..

but i want to copy only the format in a range of cells to the sheets in
the workbook..

the code copies the entire worsheet format into the other sheets. ALso
the data within then range is also to be copied.

i have got a table with headers, and formulas like sum, count

thanks


---
Message posted from http://www.ExcelForum.com/