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