View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
MSteckbeck MSteckbeck is offline
external usenet poster
 
Posts: 1
Default Formatting/Totalling Macro with varying rows of data

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?