run time erro 424

[Pete]

Hi

Cannot see the light at the end of the tunnel.........everytime i click the macro button in worksheet "Volume Summary" an error occurs just stated happening......click it and see....

giving me a run time error on the following line of vba code - in module 16 (object not defined)

With Range("B" & BaseCell.Row + Numrows - 1 & ":EC" & BaseCell.Row + Numrows - 1).Borders(xlEdgeBottom)

see attached workbook

[Pete]

ok worked out the error problem it wa ste row

For i = (BaseCell.Row + TargetRows - 1) To BaseCell.Row + 1 Step -1

missing the +1

now the demand tables are going crazy.....not sure whats casuing it

[f2e4]

I may be wrong but i think your problem lies with the line beginning:

Set Basecell = ......

This is where the object defined error starts

Basecell is being set to 0 / nothing

[Pete]

fixed object define error now

the code delete rows to clear out the old data, but it don't seem to insert new rows before you bring in the new values. This is why things looked messed up.

how do i fix this part