Macro help: Adding Specified Blank Formatted Rows Automatically?

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)
 
D

dkenebre

Thanks JE,
This site should be very useful.
I also, see where I will need to keep some data and delete others in
addition to copying formula formats, before making the 2 row copies and
pasting it in the next rows on the sheet.
I am not to familiar with VBE so I'll have to do a lot of research.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top