Move destination row

**rhudgins** · 10-26-2010, 04:17 PM

Can someone help me change the destination range to begin in column B in the second row rather then in the first?

Please Login or Register  to view this content.

Please Login or Register  to view this content.

**jaslake** · 10-26-2010, 08:23 PM

Hi rhudgins

You don't give a whole lot of information with part of a procedure and no workbook. However, based on what I see perhaps

Please Login or Register  to view this content.

This will set the destination range to rnum +1, same column (I think, can't test with no data).

John

**rhudgins** · 10-27-2010, 09:57 AM

I cannot add the workbook because the code is copying ranges from multiple workbooks. The whole procedure is in the second box of code in my first post. Your change to the destination range works, thanks. I would also like to change the following part of the code to begin in the second row of column A. I tried to add the .offset(1,0) but I am recieving an error.

Please Login or Register  to view this content.

**jaslake** · 10-27-2010, 12:25 PM

Hi rhudgins

I didn't write your code so I don't pretend to understand what it's doing. However, having read the code, to do this

I would also like to change the following part of the code to begin in the second row of column A

MIGHT be as simple as this

Please Login or Register  to view this content.

instead of this

Please Login or Register  to view this content.

John

**rhudgins** · 10-27-2010, 01:17 PM

I should have been able to figure that out on my own. Thanks!!

**jaslake** · 10-27-2010, 04:33 PM

Hi rhudgins

If your issue is solved, please mark it as such.

To mark your thread solved do the following:
- Go to the first post
- Click edit
- Click Advance
- Just below the word "Title:" you will see a dropdown with the word No prefix.
- Change to Solve
- Click Save

John