Copy a range to a different sheet and offset it

**pktrusty** · 09-29-2010, 12:13 AM

I am range on Sheet 3 that I copy and then try to paste on sheet 1 that is offset based on a counter. What should the code look like? I have tried to figure it out but I have hit a wall.

Please Login or Register  to view this content.

I know it is copying but I get a debug error when it copies.

**JBeaucaire** · 09-29-2010, 01:07 AM

If you're simply trying to paste the copied range to the bottom of the data on sheet1:

Please Login or Register  to view this content.

As per the Forum Rules, you must edit your post above and put code tags around your code like I've shown here, or remove the code from the post.

**pktrusty** · 09-29-2010, 08:12 AM

One more quick question. I am trying to copy a range that includes vlookup. When I copy, the range for the Vlookup shift. What would be the best way to prevent that. I tried to set the data range as a variable and then using that variable as the reference for Vlookup but it is not accepting my format. What would that look like? If that wouldnt work, is there a way I can just copy the values and not the formulas?

**JBeaucaire** · 09-29-2010, 08:48 AM

As per the Forum Rules, you must edit your post above and put code tags around your code like I've shown here, or remove the code from the post.

**royUK** · 09-29-2010, 08:55 AM

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here