Sub Macro1()
Range("A2:N22").Select
Selection.Copy
Range("A46").Select
Selection.PasteSpecial Paste:=xlPasteAll, Operation:=xlNone,
SkipBlanks:= _
False, Transpose:=False

End Sub


This is what the code  looks like , the range  ( A2:N22 ) is always fixed
but sometimes the data only available ,say at A2 : N14 , so I would like
to copy  only this only without carrying the whole range ( A2:N22 )