Justinlabenne
12-04-2004, 12:46 AM
Is there any way to select the last filled range of cells?
I can select the last filled row by column, (Range("A65536").End(xlUp).Select)
but how do I get it to extend to Col B, and C?
I want to be able to copy last filled row in Col A:C without having to select them individually like i do now:
Range("A65536").End(xlUp).Copy
Range("B65536").End(xlUp).Copy
Range("C65536").End(xlUp).Copy
Any ideas?
I can select the last filled row by column, (Range("A65536").End(xlUp).Select)
but how do I get it to extend to Col B, and C?
I want to be able to copy last filled row in Col A:C without having to select them individually like i do now:
Range("A65536").End(xlUp).Copy
Range("B65536").End(xlUp).Copy
Range("C65536").End(xlUp).Copy
Any ideas?