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

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

Formulas can't return this kind of formatting.

Copy|paste (manually or through code) is one way.

Another (kind of ugly) way:
Select A1 on Sheet1
edit|Copy
goto sheet2, A1
Shift-Edit|Paste picture link

Leave the formula there (or point back to the original source in all your
subsequent formulas).



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

--

Dave Peterson