When I see the following:
[ Range("A1").Select
ActiveSheet.Paste ]
I want to reduce it to [ Range("A1").Paste ]
However, this does not work. What would be the correct code for this?
When I see the following:
[ Range("A1").Select
ActiveSheet.Paste ]
I want to reduce it to [ Range("A1").Paste ]
However, this does not work. What would be the correct code for this?
why would you need to reduce it in the 1st place?
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
What is the copy code prior to that?
Be sure to put posted code into code tags, as per form rules.
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Fdibbins I have been told that it's best to consolidate code for speed and simplicity when viewing. JBeaucaire has solved my problem. Thanks!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks