How to give the column "AA" in range function of vba

Hi,

If I give

Worksheets("Sheet1").Range("AA1:A" & LastRow).Value = Worksheets("Sheet2").Range("A2:A" & LastRow).Value, the values are getting pasted into both AA1 column and 1st row of the excel sheet. I want to copy only on AA1 column.can u please help on this?



Thanks in advance
Menaka B