Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicating cell properties
Hello all and thanks in advance for any help I may get.
Here is what I am trying to do. A3 to F3 in the column headings. They are as follows: Store ID, Retailer, Last Name, First Name, Amount, and Contest. Each has its own formatiing and in B4 I have a combo box. What I would like to happen is after all required info is enter into row 4 I would like row 5 to take on the properties that row 4 had before the data was entered. Make any sense? Thanks Brian |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicating cell properties
What about:
Sub CopyFormats() ' ' CopyFormats Macro ' Macro recorded 15/04/2005 by 08504629 ' ' Rows("4:4").Select Selection.Copy Rows("5:5").Select Selection.PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _ SkipBlanks:=False, Transpose:=False End Sub -- | +-- Julian | "NOOB :-)" wrote in message ng.com... Hello all and thanks in advance for any help I may get. Here is what I am trying to do. A3 to F3 in the column headings. They are as follows: Store ID, Retailer, Last Name, First Name, Amount, and Contest. Each has its own formatiing and in B4 I have a combo box. What I would like to happen is after all required info is enter into row 4 I would like row 5 to take on the properties that row 4 had before the data was entered. Make any sense? Thanks Brian |
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) | |||
Duplicating Rows Based on Cell Value | Excel Discussion (Misc queries) | |||
Duplicating cell value between worksheets | Excel Worksheet Functions | |||
Duplicating Cell Information | Excel Worksheet Functions | |||
Duplicating a cell (EXACTLY) | Excel Programming |