Pete
08-05-2008, 07:00 AM
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
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