Hi
I have a row of 3 cells with different formulas in them. I'd like to select that row of cells and then copy down to a specific row (defined by the last row of information in a table to the left).
So, for example, I have a table with hard coded data in it from cells A1 to C10. To the right of this, I have three cells that reference that data (D1 to F1). I'd like to copy D1:F1 down to row 10. The original table may change in size, so I can't hard code row 10 as the end point for copying - this needs to be variable.
Can anyone help me do this in my macro using VBA?
Thanks!
I have a row of 3 cells with different formulas in them. I'd like to select that row of cells and then copy down to a specific row (defined by the last row of information in a table to the left).
So, for example, I have a table with hard coded data in it from cells A1 to C10. To the right of this, I have three cells that reference that data (D1 to F1). I'd like to copy D1:F1 down to row 10. The original table may change in size, so I can't hard code row 10 as the end point for copying - this needs to be variable.
Can anyone help me do this in my macro using VBA?
Thanks!