VBA copy/paste pasting to wrong row

**LITOA** · 11-25-2016, 05:22 PM

Let me start by saying that I am one of those who's best friend is Google when trying to cobble vba code together for a spreadsheet. I had the following code working, then broke it. All it is supposed to do is clear the contents of cells in AL6 to AQ & Lastrow. Copy values from several columns (A6 to C & lastrow, G6 to I & lastrow, M6 to O & lastrow, etc) and stack that data in AL6 to AN & lastrow. Then copy values from another similar set of columns and stack that data in AO6 to AQ & lastrow.

The code worked as expected, until I started messing around with code to get columns sorted. It started pasting starting in AL2 instead of AL6 and AO2 instead of AO6 as expected. I deleted the sort code. I went into the spreadsheet and manually cleared any sorting that I could find, but still pasting everything starting in row 2 instead of 6. What did I do?

Here's my code in all it's glory. May not be pretty to some here in the forum, but it used to work, at least. Any help appreciated.

Please Login or Register  to view this content.

**kasan** · 11-25-2016, 05:38 PM

Could you upload sample file with sample data?

**LITOA** · 11-25-2016, 05:41 PM

Absolutely. Give me a moment to do some trimming.

**LITOA** · 11-25-2016, 06:01 PM

Here is a sample of the problem. I have a temporary button in cell AP1 to trigger the code.

Edit: Well, apparently there is no way to remove one attachement, and replace it with another thru the edit function. Oh, well. Both are the same, only the names have been changed to protect the innocent.

**LITOA** · 11-27-2016, 01:04 AM

Thanks anyway. By going thru the logical steps of the code, I figured out that by clearing the contents of the cells in the first step, the code that I expected to paste below my 6 row header by testing for contents of a cell and then offsetting 1 row down was pasting on row 2 because my header had been cleared in the first step. Thanks to all that looked into this.