Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicating a cell (EXACTLY)
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicating a cell (EXACTLY)
One way:
Sheet1.Cells(1, 1).Copy Destination:=Sheet2.Cells(1, 1) In article , "Marty" wrote: 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? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicating a cell (EXACTLY)
That worked well. Thanks very much.
"JE McGimpsey" wrote: One way: Sheet1.Cells(1, 1).Copy Destination:=Sheet2.Cells(1, 1) In article , "Marty" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for Duplicating info from one cell to another | Excel Discussion (Misc queries) | |||
Formula for duplicating info from one cell to another | New Users to Excel | |||
Duplicating Rows Based on Cell Value | Excel Discussion (Misc queries) | |||
Duplicating cell value between worksheets | Excel Worksheet Functions | |||
Duplicating Cell Information | Excel Worksheet Functions |