Insert new row after a name range

  • Thread starter Thread starter Catherine
  • Start date Start date
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
 
Thanks Mike, your code is working but it's copying the contents also.
Can we just copy the validation and the formulas?
 
Hi Mike,

Your code is working perfectly, thank you for your help

Catherine
 
You must log in or register to reply here.

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

Insert Row also adds formulas and moves cursor 2
Return last row no. of column with blanks at top 7
Updating Code when a row is inserted 8
Keeping formulas on an insert 1
Naming non-contigent cells with vba 5
Trouble with Cutting and Inserting a Range 2
VBA - retrieve data on last create named range from previous inserted named range 0
Run-time error when copying entire row! 5

Back
Top