ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   VBA Copy Paste Issue (https://www.excelbanter.com/excel-discussion-misc-queries/254017-vba-copy-paste-issue.html)

jlclyde

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


All times are GMT +1. The time now is 03:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com