Michael, though you can find short cuts to avoid using the two commands
Range("AJ8").select
ActiveSheet.Paste

its a good idea to get use to coding this way. Later on as you code becomes
more complex you'll be much happier keeping certain routines like identify
the cell and using ActiveSheet.Paste. I learn the hard way.

"MichaelDavid" wrote:

Greetings! Does anyone know why

Range("AJ8").Select
ActiveSheet.Paste

works, but

Range("AJ8").Paste

gives the error message:

"Run-time error '438':
Object Doesn't support this property or method!

and is there anyway of accomplishing this with one instruction rather than 2
instructions. Thanks in advance for your help and suggestions.

--
May you have a most blessed day!

Sincerely,

Michael Fitzpatrick