I hope I can explain this clearly... I have a traffic log that I've put in a spreadsheet with three columns: Date, IP, and Traffic. I created a macro that turns this into a pivot table (on another sheet) that sums up the traffic by IP for the month. So far so good.

Now what I would like to do is delete the original sheet once I verify that the monthly traffic total in the pivot table matches that of the source data. I found that I can get to the pivot table's grand total with this command:

ActiveCell.SpecialCells(xlLastCell).Select
My question is: in VBA how do I sum the traffic numbers in the source sheet (column C), then compare the total with the pivot table total, and only delete the source sheet if the totals match?

Thanks,
Tom