I have managed to get all the information from a query into an excel
spreassheet using VBA. I am not sure how to set the range of a recordset or
how to provide columns on the side of the report to calculate based on the #
of records. For example, I have all the records (a:h) and in column (i) I
need to calculate (a+b).
How do I do this with VBA. The number of records from the query will
fluctuate every time the report is ran.
How do I set the function in a blank cloumn based on how many records there
are?