Hi all,
Pretty simple problem here, but for some reason I seem I am not getting it. I'm trying to select a range in Sheet 2 using Offset, with the column being offset by a cell value in Sheet 1. Then paste that range into Sheet 1. I've included by code below, and the worksheet is attached.
I would prefer to use the select method below, as this is a requirement of my project.
Many Thanks
Please Login or Register to view this content.
You have the code located in the Sheet1 worksheet code module. It should go in a standard code module e.g.; Module1. Once moved to a standard code module, it seems to work as expected.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
even though you activate sheet 2 it still copies off sheet1 (or whatever sheet is active at time of running)Please Login or Register to view this content.
maybe something like this would fix it
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hello ChrisHook,
This working macro has been relocated into a Standard VBA module. It has been added to the attached workbook.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
That all works great! Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks