Auto Fill help needed

[ashokkarale]

@jollie_ng,

Use Select Source as A2 only. This will auto fill till your column end. Try using like this.

Excel.Sheet("Sheet5").Range("A2")

Thanks,
Ashok