Pasting a range which features variables

Hi,

I am trying to copy and paste a range (a table) but the range is defined using a number of variables...as follows.

Set PDD = Range(Range(PDDCornerCell), Range(PDDCornerCell).Offset(10 + NumberofUnits, UsedNumberofColumns - 1))
Set PDRD = Range(Range(PDRDCornerCell), Range(PDRDCornerCell).Offset(10 + NumberofUnits, UsedNumberofColumns - 1))
PDD.Copy Destination:=PDRD

The number of rows and columns in the table may vary. This code will not work due to the range being an array (?). I have tried defining the range as something else first (.value=A), but that doesn't seem to work either. I thought if vba could tell me what the cell references should be based on the used number of rows and columns, I could then use these references in the copy/paste code. But I'm not sure how to do this.

Any help will be much appreciated.

Ta,
Jaclyn.