Assistance with Macro copying entire row instead of moving range

[jessls78]

Hi. I am new to writing macros. I have successfully created several macros using this website, so I am hoping you can help me with the code in one of my macros in the attached workbook. On tab "Business Detail Input", I have created a button "Insert Row" which is running the macro titled "Insert_Row". The macro is not running 100% correctly and I would like to figure out the corrections needed before I share this workbook with other users. Here's what I want the macro to do and what is working/not working so far:

1. Insert a row at the bottom of the table - Working
2. Expand the table range (BusinessDetailInput)- Working
3. Copy data validation in column A for new row - Working
4. Copy formulas in columns B & C down to new row - Working
5. Copy formulats in columns G & H down to new row - NOT WORKING. Currently the data validation is copying based on using entire row as range.
6. Data validation is copying to all columns (yes to column IV) on the new row through out the worksheet. There should be no data in columns I - IV and data validation should only be in column A for the new row. I think this is happening due to the current code copying data based on entire row as range.

Can you please provide explanation and corrections needed to VBA code so that data validation only copies in column A and formulas copy down in columns B, C, G, & H? I appreciate any help you can provide. Thank you.

[xladept]

Hi jessls,

You were erasing those formulas in G & H, try replacing

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.