Offset Equations for Column

[Ohaern]

Is there a way to include adding a series of equations to a worksheet in VBA for a range of cells that will change from day to day. The equation is simple, just =O2-M2 and then dragged down the list, so O3-M3, Etc. However how many cells will be in the column will change from day to day. I currently have it set out to about 100 more cells than we have had as a recent max, but I would definately prefer for it to simply take into account how many cells there actually are in the adjoining row.

Thanks for any help that you guys might come up with. I did include the code below, I know it is a little garbled, duct taped it together from the macro recorder.

Please Login or Register  to view this content.

[p24leclerc]

Why don't you use pre-programmed functionnality of Excel like the one which copy a cell containing a formula down the column. You double click on the lower right corner of your cell containing your formula and it will be copied down its column till there are data on either side of this column.

[JP Romano]

You could try something like

Please Login or Register  to view this content.