LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
sort macro, subtotal and add lines after subtotal David Excel Discussion (Misc queries) 1 August 29th 09 10:56 AM
Macro add row and subtotal simplymidori[_2_] Excel Discussion (Misc queries) 0 April 30th 08 12:34 AM
macro excel subtotal in subtotal GBO Excel Discussion (Misc queries) 2 November 29th 07 02:15 PM
Contitional Format SubTotal Line Cathy Excel Discussion (Misc queries) 4 April 11th 07 04:42 PM
Subtotal + Conditional Format Question Martin Ho Excel Programming 1 December 30th 03 04:32 AM


All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"