PDA

View Full Version : Sumif and sum as per mod. Num define on header



VISHAL120
10-04-2010, 06:49 AM
Hi all,

Please help me on this I have a file as attached here all I want is to make the sum ( sumif) of each column visible on the header as define on the file through VBA . I know how to do it by formula but need it on VBA. This start from Column L to Column BM.

Thanks for the help in advance.

Bob Phillips
10-04-2010, 07:55 AM
Cross-posted at MrExcel http://www.mrexcel.com/forum/showthread.php?t=499267

Aussiebear
10-05-2010, 03:46 PM
Why do people continue to do this?

vishal120, firstly, if you feel the need to cross post an issue on a number of forums, please also provide the link to the other forums. Secondly, by gaining a reputation of someone who continually cross posts issues, you will find that others will not ever assist you in the future. And this is not the direction you would like to take is it?

VISHAL120
10-05-2010, 08:42 PM
ok well noted will take this positive and will not do that

Aussiebear
10-05-2010, 10:02 PM
Excellent