Macro to sum a dynamic/variable range - I'm making this harder than it has to be, I think.

I have a workbook consisting of several sheets. Each week, the data is cleared from every sheet and replaced with new data (via a macro). The new data will have the same structure (data starts in the same row, same number of columns) every week. However, the number of rows can vary - and sometimes there is only one row of data. I currently have a macro that sums every column of every sheet - but it falters in the case where these is only one row of data to sum (there needs to be a blank row between the data and the sum).

What is the simplest way to accomplish this seamlessly? I know the code to run the operation on multiple sheets, so no need to go into that.

See attachment to really understand what I'm getting at (and how easy it seems it ought to be)

Indeed it will.

ALMOST perfect - it's not skipping a row before inserting the sum of the columns. I made the change that I thought was necessary, but it crashed Excel, so I think I didn't change the correct thing. Can you modify?

Dang! That's the change I made, but Excel then crashed on me. I guess it was just coincidence. Thanks so much!!

@ ajava

Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
Thanks.