View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JUAN JUAN is offline
external usenet poster
 
Posts: 14
Default Subtotal Format with Macro

Hello,
I want to do a Subtotal in excel and I want to create a
macro to format the cell that contains the subtotal
formula, my problem is that my file might change so if I
specified in my macro Cell A12 to format, but my Subtotal
might not be there might be in A14 depending if there's
more data in the file. So want to do my macro to format
cells that have the Subtotal formula.

Any help would be very appreciated,

thanks,
juan