When Sheet1 cell A1 is selected, press Edit-Copy
Select sheet 2 cell a1
Press Edit-Paste-Special-Formats


"Christmas May" wrote:

Perhaps this is the wrong forum, however, someone will probably know.

In cell A1 on sheet2: =Sheet1!A1

This copies the contents correctly. Any ideas how to copy the cell
formating, specfically the borders, text colors, and shading.

I don't really need VBA code, just the simple Excel
properties/formulas/functions

Thanks in advance,

Christmas May