View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
quartz[_2_] quartz[_2_] is offline
external usenet poster
 
Posts: 441
Default Enter blank row after subtotal "Total"

Hi,

It may be easiest to modify your macro to insert two rows where it finds a
change rather than one. I use code like this myself...

HTH/

"MissyLovesExcel" wrote:

I have a macro for entering a blank row when there is a change in a certain
column. However, after Subtotalling, it recognizes this Subtotal line as a
change in that category, rightfully. Can someone provide a solution/code to
enter a blank row after the Subtotal grouping? Thanks, MissyLovesExcel