Change MAcro so it adds 5 to different formula

[Jamidd1]

Hello i am currently using the following code to copy and insert rows on a spreadsheet

Please Login or Register  to view this content.

I was wondering how i could change this so that instead on adding the formula above and adding 5 it adds the following and add 5

Please Login or Register  to view this content.

Thanks

I look forward to hear from people!

[6StringJazzer]

I don't see where you are adding 5 anywhere--what do you mean by that?

Your first formula calculates a row number, and your second formula has $B$10 and $C$10 as absolute references. Do you mean to use the same calculation as used in your first version? Like this:

Please Login or Register  to view this content.

Also, I recommend you use Option Explicit to guarantee that all variables are declared, and declare l. (Also, l is not a great variable name because it can be confused with 1 when reading.)

[Jamidd1]

Hello sorry, I did not explain this very well. It copies 11 rows and pastes them after the last row with data on the worksheet. It then adds 5 to the formula that i have in column A. So ='Student Details & Data. i would like it to add 5 to a different formula the one i showed above as i have changed some elements and now the first name and surname of the student are now in separate cells.

So the bit it is adding 5 to is the Formula that links to the student details & data tab.

[6StringJazzer]

Sorry, I'm not getting this at all. It might help if you attach your file so I can see what the sheets look like.