Hi,
I want copy A to I column data, and I need to paste in second sheet. I tried in macro recording, but my problem is my VBA only copy "A1:I10" Data,

Some times I need to copy more data, But my vba only copy first 10 cell data only. how to modify this vba?

Sub love()
'
' love Macro
'

'
    Range(Selection, Selection.End(xlDown)).Select
    Range("A1:I10").Select
    Selection.Copy
    ActiveSheet.Next.Select
    ActiveSheet.Paste
    Range("A1").Select
End Sub