VBA Code to SUM specific range in a column and repeat for all the coulmns with data.

Hi All,

I can't stop myself without thanking you for the favor you do..

I need your help on the below request please.

I want to sum multiple specific ranges using vba for all the columns with data in it.

For instance:

From Column B its random that number of columns with values however my range of sum will still remain same. but its for sure that all the columns are one after other without any blank columns in the middle.

I want to sum B5:B8+B11:B14+B17:B20 and Value in B30 and if there are values in those cell in column C I need the total of those range from Column C in C30 and similarly if the values in Column D in the same range, Need the result in Cell D30.

I am trying to insert this to one of my existing MACRO.

Can someone please help me on this

Sub Total.xlsxHi Richard

Thanks for your reply,
Please find the attached spread sheet with 2 tabs one before running MACRO and other with the expected result post MACRO. Result I am expecting is in Range B85 and in all the columns towards right column <> "", with same range of sum.

Thanks once again for your time and interest.

Naresh