Hi,

I would like to use a cell reference in the following Macro

'
Sheets("PA Journal").Select
Range("A2:K2").Select
Selection.Copy
Range("A3:??").Select
Selection.PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False
Sheets("Data Entry Sheet").Select
'
Within the range("A3:??") i would like the question marks to be a reference
to a cell on the Data Entry Sheet which in turn would then return a value
from the cell of say K10 to complete the Range of cells to be copied,

Any suggestions

Thanks

Andy