VBA chaging the size of a range

[kgkev]

I currently cheat and just copy an entire row.

I'm not sure how to select the exact range I need

item.EntireRow.Copy Destination:=OS.Range("A65000").End(xlUp).Offset(1)

item is a cell starting at A and I want it extend only to F

I tried

OS.Range(item.cell, item.cell.Offset(, 5)).Copy Destination:=OS.Range("A65000").End(xlUp).Offset(1)

But that didn't work.

Any ideas?

 

[Andrew Poulsom]

Maybe try:

item.EntireRow.Resize(, 6).Copy Destination:=OS.Range("A65000").End(xlUp).Offset(1)

 

[kgkev]

spot on thanks.