Autosum function in a Macro

Hi All,

I am trying to write a macro that allows me to autosum a differing amount of rows each time a run it.

I start in a row in column K then insert 2 rows, move left to column B then sum all the cells until there is a space.

Then I autofill this formula from Column B to Column I and Bold the figures. Then clear Column F.

My problem is the autosum function of the macro below:

Please Login or Register  to view this content.

Any Help would be greatly appreciated.

Many thanks

Cam

Like so:

Please Login or Register  to view this content.

I'm not sure what the code at the end is supposed to be doing, so I left that out for now.