jamescooper
Well-known Member
- Joined
- Sep 8, 2014
- Messages
- 840
Code:
Range("AG2:BC1000").Copy Sheets("Data").Cells(Sheets("Data").Rows.Count, "D").End(xlUp).Offset(1, 0)
The code above copy and pastes the range specified from the current sheet to the data sheet.
To improve this I would like it to copy the range down to the last populated row but this could be in either column AG, AK, AO, AS, AW or BA.
Any idea how I could achieve this please?