Fill function to next cells
Hi Joel,
Thanks again for that. That's pretty much it. But I don't need a column
inserted because I've already done that. I just need the cells functions
copied in to the cells to the right. So that's probably a cross between the
first and second answers that you gave me. I'm close to knowing all of this
myself but haven't quite got there yet. You are helping loads though.
Thanks
Carl
"Joel" wrote:
Is this better
Sub test()
LastCol = Cells(10, Columns.Count).End(xlToLeft).Column
Set copyrange = Range(Cells(10, LastCol - 1), Cells(20, LastCol - 1))
copyrange.Copy
copyrange.Offset(0, 1).Insert Shift:=xlToRight
End Sub
|