I have data stored in Columns A through AZ but only want to copy A,B, and C to the last cell.
I was using
However, if I try adding the cells it does not copy those ranges. Is there a way that I can achieve this with the code I provided or is there a different method to achieve this?
I was using
Rich (BB code):
Range(Range("A5"), Range("A5").End(xlDown)).Select
However, if I try adding the cells it does not copy those ranges. Is there a way that I can achieve this with the code I provided or is there a different method to achieve this?