I'm trying to use a macro to copy the value in row 2 of a column and paste it in all the cells below. I would like to use it in columns of variable lengths. I had a macro that was working (although it always gave me a few extra rows of the value), but now it doesn't. I didn't think I'd made any changes to it, but here's what I have now:
Sub fill_column()
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1:A" & Range("A1000").End(xlUp).Row).Select
ActiveSheet.Paste
End Sub
What do I have wrong?
Thanks in advance!
Sub fill_column()
Selection.Copy
ActiveCell.Offset(1, 0).Range("A1:A" & Range("A1000").End(xlUp).Row).Select
ActiveSheet.Paste
End Sub
What do I have wrong?
Thanks in advance!