Hi,

Why don't you show us your code. Also, are the only thing that changes the
number of rows?

--
Cheers,
Shane Devenshire


"MSteckbeck" wrote:

Fairly new to VBA, so I'm struggling with how to write a formatting macro for
an excel file. The file is automatically generated by Access with each report
run, but each report run could have a varying number of rows. How do I write
the formatting macro so that I can both format the columns/rows as needed and
put in the sum at the bottom of each data?