I have formulas in cells a2 through i2; based on cell J2's data, I would like the cells in a2 through i2 to fill down to where the data stops. I tried using the formula below but
it doesn't seem to work properly. I think its just a little off. If you know let me know. Thanks!
it doesn't seem to work properly. I think its just a little off. If you know let me know. Thanks!
VBA Code:
Range("a2:I2").Select
Selection.End(xlDown).Select
ActiveCell.Offset(0, 10).Select
Range(Selection, Selection.End(xlUp)).Select
Selection.FillDown