Duplicating a cell (EXACTLY)

[Guest]

Hi all:

I'm using Excel 2003. I need to know how to duplicate a cell (both the
contents AND any formatting) from one sheet of a workbook to another.

Normally, I would use:

{Dim, Set}
Sheet2.Cells(1,1) = Sheet1.Cells(1,1)

but this only duplicates the contents. If, for example, the cell on Sheet1
contained MARTY, with a red background and bold italics font with a cell
comment, the cell in Sheet2 would contain MARTY with default background and
font settings and no comment.

How can I make an EXACT duplicate of the cell?

Please advise. Thanks in advance.

MARTY

 

[JE McGimpsey]

One way:

Sheet1.Cells(1, 1).Copy Destination:=Sheet2.Cells(1, 1)

 

[Guest]

That worked well. Thanks very much.

One way:

Sheet1.Cells(1, 1).Copy Destination:=Sheet2.Cells(1, 1)