#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 410
Default VBA Copy Paste Issue

I have a workbook that is used by multiple users and the copy paste
lines of the code do not work on the newer computers. It gets hung up
when I code Range("A1:A5").copy Range("A1").pasteSpecial Xlvalues. I
do not understand why this does not work on all computers. It errors
out and tells me that it can not paste because the range is nto the
same. So then I have to speciff Range("A1:A5") to paste.....this does
not make sense to me.

Thanks,
Jay
Reply
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
Copy and Paste Issue 2007 SP1 Tim Excel Discussion (Misc queries) 2 March 21st 09 01:45 PM
Office 2007 Copy Paste Issue anshuman Excel Discussion (Misc queries) 5 August 18th 07 09:38 PM
Copy & Paste Issue carrera0000 Excel Discussion (Misc queries) 3 August 17th 07 02:24 AM
Copy Paste issue amwebber Excel Worksheet Functions 3 October 31st 06 02:08 AM
Issue with copy & paste? Etrnal168 Excel Discussion (Misc queries) 2 July 12th 05 03:35 AM


All times are GMT +1. The time now is 05:17 PM.

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

About Us

"It's about Microsoft Excel"