Hello All
I have the below from the recorder. The problem, is the formula computes all the way to the bottom, and my data ends much sooner, so the program really slows down.
How do I have the formula compute to the end of cells that it is requiring? For example if in this example, the formula is only grabbing numbers from columns E& F, down to row 3200 (this will be different every time I load new raw data) how can it stop at 3200, instead of going all the way down?
Thanks for the help
I have the below from the recorder. The problem, is the formula computes all the way to the bottom, and my data ends much sooner, so the program really slows down.
How do I have the formula compute to the end of cells that it is requiring? For example if in this example, the formula is only grabbing numbers from columns E& F, down to row 3200 (this will be different every time I load new raw data) how can it stop at 3200, instead of going all the way down?
Thanks for the help
VBA Code:
Range("I2").Select
Application.CutCopyMode = False
ActiveCell.FormulaR1C1 = "=RC[-3]-RC[-4]"
Range("I2").Copy
Range("I3").Select
Range(Selection, Selection.End(xlDown)).Select
ActiveSheet.Paste