hardcoremark
01-23-2013, 02:33 PM
Hi,
I have recorded a macro, part of which includes inserting a line of text in the first cell of a column and then copying it down to correspond with the last row of text contained within other columns. So the code I have at the moment is as follows;
ActiveCell.FormulaR1C1 = "Upcoming Releases"
Range("I1").Select
Selection.AutoFill Destination:=Range("I1:I200")
Range("I1:I200").Select
The problem is that the last row of text in the other columns is always different. How can I change the code so that it automatically fills to the last row?
Thanks,
Mark.
I have recorded a macro, part of which includes inserting a line of text in the first cell of a column and then copying it down to correspond with the last row of text contained within other columns. So the code I have at the moment is as follows;
ActiveCell.FormulaR1C1 = "Upcoming Releases"
Range("I1").Select
Selection.AutoFill Destination:=Range("I1:I200")
Range("I1:I200").Select
The problem is that the last row of text in the other columns is always different. How can I change the code so that it automatically fills to the last row?
Thanks,
Mark.