I have created a Macro which picks up data from two seperate Access databases
and populates the XL sheets. One of the function of this macro is to pull
data from an Access database and apply subtotals onto to the sheet.

Now this works perfectly fine till the time the information pulled is not
blank.

Now suppose the data pulled has zero records, the Macro stops since there
are nothing to be subtotalled.
How do I fix this. ?