Copying/paste specific Range

[williadb]

Hi

Im trying to copy all data from one worksheet and paste to another worksheet. However it may be possible that additional rows and columns are added to the spreadsheet over time so id like to always ensure that i am copying all of the info across.

I have a cell called "end of data" on 1 work sheet. Im using the find function then using Range(Selection, Selection.End(xlToLeft)).Select and Range(Selection, Cells(1)).Offset(1, x).Copy to select the data.

The issues is that i am actually capturing the top row however i require the data from row 3 to the end of data

can anyone please assist me
Thx

 

[wigi]

Why not somethin like:

Sub copying()
    With ActiveSheet.UsedRange
        .Offset(2).Resize(.Rows.Count - 2).Copy destination:=...
    End With
End Sub

or:

Sub copying_2()
    With [A1].CurrentRegion
        .Offset(2).Resize(.Rows.Count - 2).Copy destination:=...
    End With
End Sub

 

[williadb]

Many thanks. Nice website

 

[wigi]

Many thanks. Nice website

Thanks You're welcome.