Learn Excel from Bill Jelen with this daily 2 minute video podcast.

Thursday, September 11, 2008

Episode 844 - AutoSum Macro

Mark asks about how to replicate the AutoSum concept in a macro. The code in Episode 844 gets closer to the AutoSum functionality than the solution that I proposed in Episode 812.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: ,

Wednesday, August 13, 2008

Episode 823 - Recording AutoSum

Mark from New Hampshire notes that the macro recorder can not record the simple act of pressing the AutoSum button. In Episode 823, I show you the arcane workaround to solve the problem.

This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

Labels: , ,

Thursday, September 28, 2006

Episode 350 - Total Visible Rows

There is another way to use the AutoSum icon in the standard toolbar. This alternate method will show you the totals of the visible cells, ignoring cells in hidden rows. Episode 350 shows you how.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

Labels: ,