D
dkenebre
How do I make a macro that will prompt with a dialog box to copy the
rows a certain number of times. For example, if I have 2 rows of data
and I want to be able to specified any number of copies of the 2 rows
blank without the data but maintain the formats (colors, condition,
formulas, code, etc.). I want to add the rows to the existing
worksheet. Also, I would want to this macro to be flexible to maintain
it’s function if I add or delete columns from the chart.
See sample chart
File Attached: http://www.exceltip.com/forum/attachment.php?postid=279064 (question5 sample1.xls)
rows a certain number of times. For example, if I have 2 rows of data
and I want to be able to specified any number of copies of the 2 rows
blank without the data but maintain the formats (colors, condition,
formulas, code, etc.). I want to add the rows to the existing
worksheet. Also, I would want to this macro to be flexible to maintain
it’s function if I add or delete columns from the chart.
See sample chart
File Attached: http://www.exceltip.com/forum/attachment.php?postid=279064 (question5 sample1.xls)