VBA Ranges question

[Isabella]

Hi, i have the below code which copies from A3:C and then exports to A6. Is there a way to limit the copy and only copy the UsedRange from A3:C?

Sub Testing()

Dim LastRow As Long
Dim shtDst As Worksheet
Dim shtTest As Worksheet

Set shtDst = Sheets("Raw")
Set shtTest = Sheets("Test")

    With Sheets(shtTest)
            LastRow = Range("A" & Rows.Count).End(xlUp).Row
            With .Range("A3:C" & LastRow)
                 .Copy
                 shtDst.Range("A6").PasteSpecial xlPasteValues
            End With
    End With
End Sub

 

[Isabella]

*bump*

 

[Norie]

Isn't that what the code already does?

 

[Isabella]

Isn't that what the code already does?

I figured it out, this works

With .Range("A3").CurrentRegion.Resize(, 3)

 

[mirabeau]

I figured it out, this works

With .Range("A3").CurrentRegion.Resize(, 3)

That may also include items in the range(A1:C2).

Is this what you want?

 

[Isabella]

That may also include items in the range(A1:C2).

Is this what you want?

There is 2 row gap so it does not include those rows