LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 100
Default Range object does not support paste method

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Object doesn't support this property or method clara Excel Programming 5 May 3rd 07 05:14 PM
438 - Object doesn't support this property or method Revtim Excel Programming 0 September 12th 05 09:09 PM
Object doesn't support this method Andibevan[_4_] Excel Programming 3 September 1st 05 10:07 AM
Object doesn't support this property or method davegb Excel Programming 11 May 12th 05 03:36 PM
Object doesn't support this property or method Rick Campbell Excel Programming 2 July 13th 03 11:53 PM


All times are GMT +1. The time now is 06:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"