Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cell properties from master when user enters a new line.
Is there a VB command that can copy the formats, formulas and Data Validation
from one cell into another cell. I have a spreadsheet that I have created all the cell formats (bold, font, Data Validation) in line 6. If the user enters into a new line I would like to copy the structure of line 6 to the new line they are entering on (same column). Thanks Hippy |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy cell properties from master when user enters a new line.
David McRitchie has a nice macro that asks how many rows should be inserted and
even copies the formulas down to those new rows. http://www.mvps.org/dmcritchie/excel/insrtrow.htm look for: InsertRowsAndFillFormulas Maybe you can modify it to always point at row 6??? Hippy wrote: Is there a VB command that can copy the formats, formulas and Data Validation from one cell into another cell. I have a spreadsheet that I have created all the cell formats (bold, font, Data Validation) in line 6. If the user enters into a new line I would like to copy the structure of line 6 to the new line they are entering on (same column). Thanks Hippy -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Out of range line disappears in print as it re-enters graph | Charts and Charting in Excel | |||
Master worksheet automatically enters data into sub worksheets | Excel Discussion (Misc queries) | |||
How do I make all VBA routines offlimits until a user enters the correct password | Excel Programming | |||
workbook and application reference set to null after the user enters something in an excel sheet | Excel Programming | |||
User enters data in popup box - its entered into desired cell | Excel Programming |