kai.lau
01-15-2018, 06:49 AM
Hello all,
I am trying to copy a row of cells/formulas down x amount of times based on a cell value.
For example; Range ("A6:J6") x number of times (specified by a formula in cell "D3"-1), beneath "A6:J6". Can someone help? I have just started to learn about bits of VBA so don't quite fully understand destination ranges currently. Any help would be appreciated.
21353
So A6:J6 needs to applied down to row A6+2:J6+2? Hope that makes sense.
I am trying to copy a row of cells/formulas down x amount of times based on a cell value.
For example; Range ("A6:J6") x number of times (specified by a formula in cell "D3"-1), beneath "A6:J6". Can someone help? I have just started to learn about bits of VBA so don't quite fully understand destination ranges currently. Any help would be appreciated.
21353
So A6:J6 needs to applied down to row A6+2:J6+2? Hope that makes sense.