Need help with copying in VBA

[wroze27]

I am running a filter that loops through 900+ rows in a sheet and copies certain rows into other specific sheets based on a column value. I have everything else set up but I am struggling to get the copy function to work. I need to use "i" as a row reference and need to copy columns "A:G".

Any help would be appreciated. Thanks

This what I thought would work

Sheet1.Cells(i,"A:G").Copy Sheet2.Cells(LastRow,"A")

 

[Fluff]

Try it like

Sheet1.Cells(i,"A").Resize(, 7).Copy Sheet2.Cells(LastRow,"A")