Insert new row after a name range

C

Catherine

Hi,

I am new on this site and I don't know really much about VBA, can you help
me?

I want to copy the validation of he cells A5:B5 and the formulas of cells
E5:F5 into a new row inserted after the range name "Training".

Thanks
 
C

catherine

Thanks Mike, your code is working but it's copying the contents also.
Can we just copy the validation and the formulas?
 

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

Similar Threads

Return last row no. of column with blanks at top 7
Keeping formulas on an insert 1
Naming non-contigent cells with vba 5
Insert Row also adds formulas and moves cursor 2
Updating Code when a row is inserted 8
Run-time error when copying entire row! 5
Macro or VBA to Clear Contents of Rows By Date (Starting At A5) 1
VBA Insert Into Specific Cell 0

Top