Excel Macro - Copy & Paste (Font) problem & Delete Last Added Rows problem

Dear all,

Since I've started building Macro's there are some problems with which I need some help.
Here is the file (at least, a mock version of it) with my current situation: Marco Problem by forum.xlsm.

Currently, it works as follows: the upper table (<Template>) fills from a different worksheet, which is then copied and pasted (as values instead of formulas) below (tables '1' and '2'). So, each time a new project is added (cells are filled in on another sheet), it copies this new project and pastes it below the last table.
There are two things I need to add but can't manage to build in:
- When the table is copied, I need it to be pasted in a different font (for example the font of table '1')
- I need a macro that clears/deletes the last added project(/table). Deleting a certain range is not the problem, getting this range to be the last added project/table is.
Could you guys help me with this? I'd be incredibly grateful!

Cheers,

LennartB

Hi TMS,

Thanks for your quick response and the code provided!
It was very useful to me, although I needed to 'Clear' the cell & adjust them to the font I use instead of using 'ClearContent'.
However, with your code as a guideline, combined with my limited knowledge of VBA, I've managed to get just what I needed:

Please Login or Register  to view this content.

Ignore change in the sheetname and columns, that's of course to get a fitting transfer. A thanks a ton for making this possible!

And now, there is my second problem. Right now, I am able to copy&paste the right cells in the right place (below each other) and now I am also able to delete these (last pasted) cells. The last thing I need is a font change, only for the pasted cells.
With my current knowledge, I've been able to correctly adjust the font only of the first set of pasted cells. So, in other words, my font change code is static where I need it to be changing with range, dynamic. This means that every part of cells pasted below gets the same font.

This is my code:

Please Login or Register  to view this content.

I guess that right at the lines I've made bold, I need to insert this 'dynamic code', the sort of code used in the underlined/italic lines.
Lots of thanks in advance!

Cheers

You're absolutely right, I'll do that.

Thanks again!