Do you mean you'd like to copy the format of a1:a10 to c1:c10, without
copying values? Or is a1:a10 a named range?