calculating individual cells within large ranges

Good Afternoon all,

I am quite new to macro's, but am trying to do a simple task of adding cells from 2 different worksheets into a third sheet.

So I want Cell B3 of sheet1 added to Cell B4 of Sheet2 and the total to appear in Cell B3 of Sheet 3.

The code I have got to work is:

Please Login or Register  to view this content.

This works, but I need to get this method to work for all cells in a range (add each cell from Sheet1 from B4 to U46 inclusive, and Sheet2 B3 to U45 inclusive, to appear in sheet 3 in the range of B4 to U46).

Is it possible to do this by a simple peive of code? or will I have to enter each calculation seperately like:

Please Login or Register  to view this content.

this seems to work but would take me ages to input all the different cell calculations.

Any advice would be warmly received.

Ian.

Try this

Please Login or Register  to view this content.

Hope this works

Sorry missed that bit
Try this

Please Login or Register  to view this content.

Is that better?